excelize
excelize copied to clipboard
qax-os
Go language library for reading and writing Microsoft Excel™ (XLAM / XLSM / XLSX / XLTM / XLTX) spreadsheets
the source code ： ```go xlsx := excelize.NewFile() // 创建一个工作表 index := xlsx.NewSheet("Sheet2") // 设置单元格的值 xlsx.SetCellValue("Sheet2", "A2", "Hello world.") rowHeight := xlsx.GetRowHeight("Sheet2", 2) fmt.Println("the 2 row height: ", rowHeight) xlsx.SetCellValue("Sheet2",...
Is there a way to change existing table range? For example: 1. Get table by name 2. Set new range instead let's say "A1:P8000" to "A1:P1000" Thank you in advance.
As of now, you can only add a new pivot table with the AddPivotTable function and not reference an existing pivot table. I am looking for a way to refresh...
Addpicture format `x_scale` and `y_scale` can work，but the value in excel is different from setting value. e.g. set `x_scale` and `y_scale` all 0.03，when I open the excel，actually height scale is...
Hello, Is it possible to add queryTables, especialy for web query ? I would like to create excel with embeded data from external data source via web query ... (IQY)...
On sheets where we need to remove hundreds of columns multiple calls to `f.RemoveCol` is very slow. I suggest a new version be implemented which enables bulk removal of a...
At the moment, any sort of filter operation where rows are (iterated in any order) and then deleted is very slow. This is mainly due to the fact that the...
I want to read excel's (xlsx) format's content in a textbox? Is there any method to achieve this?
**Description** Unable to fetch a sheet with more than 31 characters in its name. I know this is not supported by Microsoft Excel but this issue prevents a user from...
How to set the style of the graph? I need to change the color and add lines. This default chart http://prntscr.com/jr2a8c need a http://prntscr.com/jr2b0k
