xuri
b14b74bf56
This closes #873 , make the sheet names are not case sensitive for `NewSheet`, `GetSheetIndex`, `DeleteSheet`
4 years ago
xuri
544ef18a8c
- Support concurrency iterate rows and columns
...
- Rename exported field `File.XLSX` to `File.Pkg`
- Exported error message
4 years ago
xuri
36b7990d6b
lint issue fixed and new formula function: ATAN, AVERAGE, AVERAGEA, CONCAT, CONCATENATE, COUNT, COUNTBLANK, MAX
4 years ago
xuri
1f329e8f96
This closes #774 , closes #775 and closes #776
...
- correct adjust calculation chain in duplicate rows
- correct adjust defined name in the workbook when delete worksheet
- use absolute reference in the auto filters defined name to make it compatible with OpenOffice
- API `CoordinatesToCellName` have a new optional param to specify if using an absolute reference format
- Fix cyclomatic complexity issue of internal function `newFills` and `parseToken`
4 years ago
xuri
b260485f29
support to set print black and white and specified the first printed page number
4 years ago
xuri
054bb9f061
Support to adjust print scaling of the worksheet
4 years ago
xuri
13e0ed2a69
Fixed #735 , refresh active tab after delete sheet
4 years ago
xuri
5dd0b4aec2
using POSIX directory separator in zip path with Windows
4 years ago
Ted
fcca8a3838
optimize memory allocation ( #722 )
...
* optimize marshal
* optimize mem alloc
* add benchmark testing
* add NewSheetWithRowNum testing
* sync struct fields order
* add BenchmarkNewSheetWithStreamWriter
* delete NewSheetWithRowNum and benchmark test
4 years ago
xuri
4834a058aa
This closes #714 and closes #715 , fix wrong worksheet index returned by NewSheet in some case, fix panic on formatted value with no built-in number format ID
4 years ago
xuri
520aa679f3
Fix #706 , #713 improve AddPicture performance, fix missing worksheet when rename with same names
4 years ago
Artem Kustikov
f2b8798a34
extend cell value load to support custom datetime format ( #703 )
...
* extend cell value load to support custom datetime format
* cleanup incorrect imports
* fix numeric values conversion as done in legacy Excel
* fix tests coverage
* revert temporary package name fix
* remove personal info from test XLSX files
* remove unused dependencies
* update format conversion in parseTime
* new UT to increase code coverage
* Resolve code review issue for PR #703
* Rename broken file name generated by unit test
Co-authored-by: xuri <xuri.me@gmail.com>
4 years ago
xuri
1fe660df64
- Resolve #485 use sheet index instead of ID
...
- added 3 internal function: getSheetID, getActiveSheetID, getSheetNameByID
5 years ago
xuri
1d87da57ec
Resolve #492 , init support for insert and remove page break
5 years ago
xuri
ad883caa0f
Resolve #580 , revert commit 5ca7231ed4
5 years ago
xuri
5ca7231ed4
optimize code and comments: use println errors instead of panic
5 years ago
xuri
1666d04559
optimization: checking error in unit tests
5 years ago
xuri
ae2865d923
Improve code coverage unit tests
5 years ago
xuri
5e418ebd66
Resolve #507 , add the new function `DeleteDefinedName`
5 years ago
xuri
87390cdd99
Resolve #511 , allow empty columns in the pivot table
5 years ago
xuri
2e791fa433
Optimize code of Getting/Setting Page Margins
5 years ago
streboryaj
2d21b5b50f
Added accessors for Getting/Setting Page Margins ( #497 )
...
* Added accessors for Getting/Setting Page Margins
* Added test cases
5 years ago
Ben Wells
3c327413d9
Fix dependency on github.com/360EntSecGroup-Skylar/excelize v1
5 years ago
xuri
0acb3ef968
Testing files updated
5 years ago
Harris
faaaa52cb8
Get sheet names based on index
...
SheetID only seems to indicate the file name for the sheet.
Check the sheets list based on index instead. Reordering sheets
in Excel changes the order they appear in that list.
Fixes #457
6 years ago
xuri
14d490c83d
Add unit test for SetPageLayout
6 years ago
xuri
e780aa27c8
Add unit test for GroupSheets and UngroupSheets
6 years ago
xuri
a335be7e4e
New functions: SetDefinedName and GetDefinedName added
6 years ago
xuri
69b38ddcd6
Resolve #394 , init set header and footer support
6 years ago
xuri
b1f632d408
Resolve #393 , upgrade Go module to v2
6 years ago
xuri
a88459d5f1
add unit tests to functions
6 years ago
kkxkkxkkgh
81948d9e1e
The function SetPageLayout support set paper size
6 years ago
zhangleijlu
034de7acd8
Resolve #318 , add new functions and
6 years ago