summaryrefslogtreecommitdiff
path: root/excelize_test.go
Commit message (Collapse)AuthorAge
* Remove internal error log print, throw XML deserialize errorxuri2022-11-13
|
* This is a breaking change, remove partial internal error log print, throw ↵xuri2022-11-12
| | | | | | | XML deserialize error - Add error return value for the `GetComments`, `GetDefaultFont` and `SetDefaultFont` functions - Update unit tests
* This closes #1204, breaking changes for add commentsxuri2022-11-02
| | | | | - Allowing insert SVG format images - Unit tests updated
* This close #1373, fixes the incorrect build-in number format apply the resultxuri2022-10-20
| | | | | - An error will be returned when setting the stream row without ascending row numbers, to avoid potential mistakes as mentioned in #1139 - Updated unit tests
* Go 1.16 and later required, migration of deprecation package `ioutil`xuri2022-10-13
| | | | | | - Improving performance for stream writer `SetRow` function, reduces memory usage over and speedup about 19% - Update dependencies module - Update GitHub workflow
* This closes #1358, made a refactor with breaking changes, see details:xuri2022-09-29
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | This made a refactor with breaking changes: Motivation and Context When I decided to add set horizontal centered support for this library to resolve #1358, the reason I made this huge breaking change was: - There are too many exported types for set sheet view, properties, and format properties, although a function using the functional options pattern can be optimized by returning an anonymous function, these types or property set or get function has no binding categorization, so I change these functions like `SetAppProps` to accept a pointer of options structure. - Users can not easily find out which properties should be in the `SetSheetPrOptions` or `SetSheetFormatPr` categories - Nested properties cannot proceed modify easily Introduce 5 new export data types: `HeaderFooterOptions`, `PageLayoutMarginsOptions`, `PageLayoutOptions`, `SheetPropsOptions`, and `ViewOptions` Rename 4 exported data types: - Rename `PivotTableOption` to `PivotTableOptions` - Rename `FormatHeaderFooter` to `HeaderFooterOptions` - Rename `FormatSheetProtection` to `SheetProtectionOptions` - Rename `SparklineOption` to `SparklineOptions` Remove 54 exported types: `AutoPageBreaks`, `BaseColWidth`, `BlackAndWhite`, `CodeName`, `CustomHeight`, `Date1904`, `DefaultColWidth`, `DefaultGridColor`, `DefaultRowHeight`, `EnableFormatConditionsCalculation`, `FilterPrivacy`, `FirstPageNumber`, `FitToHeight`, `FitToPage`, `FitToWidth`, `OutlineSummaryBelow`, `PageLayoutOption`, `PageLayoutOptionPtr`, `PageLayoutOrientation`, `PageLayoutPaperSize`, `PageLayoutScale`, `PageMarginBottom`, `PageMarginFooter`, `PageMarginHeader`, `PageMarginLeft`, `PageMarginRight`, `PageMarginsOptions`, `PageMarginsOptionsPtr`, `PageMarginTop`, `Published`, `RightToLeft`, `SheetFormatPrOptions`, `SheetFormatPrOptionsPtr`, `SheetPrOption`, `SheetPrOptionPtr`, `SheetViewOption`, `SheetViewOptionPtr`, `ShowFormulas`, `ShowGridLines`, `ShowRowColHeaders`, `ShowRuler`, `ShowZeros`, `TabColorIndexed`, `TabColorRGB`, `TabColorTheme`, `TabColorTint`, `ThickBottom`, `ThickTop`, `TopLeftCell`, `View`, `WorkbookPrOption`, `WorkbookPrOptionPtr`, `ZeroHeight` and `ZoomScale` Remove 2 exported constants: `OrientationPortrait` and `OrientationLandscape` Change 8 functions: - Change the `func (f *File) SetPageLayout(sheet string, opts ...PageLayoutOption) error` to `func (f *File) SetPageLayout(sheet string, opts *PageLayoutOptions) error` - Change the `func (f *File) GetPageLayout(sheet string, opts ...PageLayoutOptionPtr) error` to `func (f *File) GetPageLayout(sheet string) (PageLayoutOptions, error)` - Change the `func (f *File) SetPageMargins(sheet string, opts ...PageMarginsOptions) error` to `func (f *File) SetPageMargins(sheet string, opts *PageLayoutMarginsOptions) error` - Change the `func (f *File) GetPageMargins(sheet string, opts ...PageMarginsOptionsPtr) error` to `func (f *File) GetPageMargins(sheet string) (PageLayoutMarginsOptions, error)` - Change the `func (f *File) SetSheetViewOptions(sheet string, viewIndex int, opts ...SheetViewOption) error` to `func (f *File) SetSheetView(sheet string, viewIndex int, opts *ViewOptions) error` - Change the `func (f *File) GetSheetViewOptions(sheet string, viewIndex int, opts ...SheetViewOptionPtr) error` to `func (f *File) GetSheetView(sheet string, viewIndex int) (ViewOptions, error)` - Change the `func (f *File) SetWorkbookPrOptions(opts ...WorkbookPrOption) error` to `func (f *File) SetWorkbookProps(opts *WorkbookPropsOptions) error` - Change the `func (f *File) GetWorkbookPrOptions(opts ...WorkbookPrOptionPtr) error` to `func (f *File) GetWorkbookProps() (WorkbookPropsOptions, error)` Introduce new function to instead of existing functions: - New function `func (f *File) SetSheetProps(sheet string, opts *SheetPropsOptions) error` instead of `func (f *File) SetSheetPrOptions(sheet string, opts ...SheetPrOption) error` and `func (f *File) SetSheetFormatPr(sheet string, opts ...SheetFormatPrOption
* This closes #1360, closes #1361xuri2022-09-28
| | | | | | | - Fix default number format parse issue with a long string of digits - Fix creating a sheet with an empty name cause a corrupted file - The `GetCellStyle` function no longer return master cell style of the merge cell range - Using the specialized name in variables and functions
* Using the specialized name in a variable and making comments clearxuri2022-09-18
| | | | - Add JSON tags for `AppProperties`, `PivotTableOption` and `PivotTableField` structure
* This makes 6 functions concurrency safetyxuri2022-09-11
| | | | - These 6 functions now support concurrency safe: SetColWidth, GetColWidth, SetColVisible, GetColVisible, SetColStyle and GetColStyle
* This closes #744, the `Save`, `Write` and `WriteTo` function accept saving ↵xuri2022-09-08
| | | | options
* This closes #1323, an error will be returned when set the not exist style IDxuri2022-09-01
|
* This closes #1330 update non existing sheet error messages (#1331)davidborry2022-08-28
|
* This closes #827, add new functions `GetDataValidations` and ↵chenliu19932022-08-27
| | | | | `GetConditionalFormats` (#1315) Signed-off-by: chenliu1993 <13630583107@163.com>
* This closes #1247, add new function `SetSheetCol` for set worksheet column ↵Cooper de Nicola2022-08-25
| | | | | | values (#1320) Signed-off-by: cdenicola <cooper.denicola@instabase.com> Co-authored-by: cdenicola <cooper.denicola@instabase.com>
* make workbook open filed exception message clearxuri2022-05-20
| | | | | - New exported constant `ErrWorkbookPassword` - Rename exported constant `ErrWorkbookExt` to `ErrWorkbookFileFormat`
* This closes #1229, rename ErrMaxFileNameLength to ErrMaxFilePathLength (#1230)sceneq2022-05-16
| | | Co-authored-by: sceneq
* This closes #1217, support update cell hyperlinkxuri2022-05-01
| | | Ref #1129, make `SetRowStyle` overwrite style of the cells
* Format code, update documentation and remove exported variable `XMLHeaderByte`xuri2022-03-24
|
* ref #65, new formula functions and read boolean data type cell value supportxuri2022-03-08
| | | | * added 3 new formula functions: BETAINV, BETA.INV, F.INV.RT
* This closes #1129, make cell support inheritance columns/rows stylexuri2022-01-27
| | | | | | Correct cells style in merge range Fix incorrect style ID returned on getting cell style in some cases Unit test updated and simplified code
* Fix file corrupted in some cases, check file extension and format codexuri2022-01-23
| | | | | | Fix file corrupted when save as in XLAM / XLSM / XLTM / XLTX extension in some case New exported error ErrWorkbookExt has been added, and check file extension on save the workbook Format source code with `gofumpt`
* Typo fix, rename exported constants, dependencies modules and copyright updatexuri2022-01-09
| | | | Rename exported constants `NameSpaceDublinCoreMetadataIntiative` to `NameSpaceDublinCoreMetadataInitiative`
* feat: implement SHA-512 algorithm to ProtectSheet (#1115)Jonham.Chen2022-01-08
|
* This closes #1096, memory usage optimization and another 4 changesxuri2021-12-27
| | | | | | | | - Unzip shared string table to system temporary file when large inner XML, reduce memory usage about 70% - Remove unnecessary exported variable `XMLHeader`, we can using `encoding/xml` package's `xml.Header` instead of it - Using constant instead of inline text for default XML path - Rename exported option field `WorksheetUnzipMemLimit` to `UnzipXMLSizeLimit` - Unit test and documentation updated
* This closes #1097, initialized formula function XLOOKUP and update testxuri2021-12-25
|
* Export 7 errors so users can act differently on different type of errorsxuri2021-12-07
|
* This closes #833, closes #845, and closes #1022, breaking changesxuri2021-09-19
| | | | | | - Close spreadsheet and row's iterator required - New options `WorksheetUnzipMemLimit` have been added - Improve streaming reading performance, memory usage decrease about 93.7%
* Add set shared formula support and documentation for the `SetCellFormula`xuri2021-09-03
|
* This closes #844, support get shared formularaochq2021-08-15
|
* Improve security and simplify codexuri2021-08-15
| | | | | | | - Make variable name more semantic - Reduce cyclomatic complexities for the formula calculate function - Support specified unzip size limit on open file options, avoid zip bombs vulnerability attack - Typo fix for documentation and error message
* change go module import path to github.com/xuri/excelizexuri2021-07-28
|
* This closes #872, support re-save the new spreadsheet after `SaveAs`xuri2021-07-09
|
* - Support concurrency iterate rows and columnsxuri2021-07-05
| | | | | - Rename exported field `File.XLSX` to `File.Pkg` - Exported error message
* This closes #861, support concurrency get cell picture and remove unused ↵xuri2021-07-04
| | | | internal function `getSheetNameByID`
* This closes #409 Remove UTC timezone requirement from date.go (#853)Alluuu2021-06-04
| | | | | | | According to issue #409 There is absolutely no reason for the timezone to be in UTC, and converting the local times to UTC while keeping values is hacky at least. Excel has no understanding of timezones, hence the user of this library should know what timezone their values are supposed to be, by following the timezone within their timeTime structs.
* This closes #652, new SetColWidth API, support set column width in stream ↵xuri2021-05-10
| | | | writing mode, and export error message
* Fixe issue generated file corrupted caused by incorrect default XML ↵xuri2021-04-30
| | | | namespace attributes
* #65 fn: N, PERCENTILE.INC and Txuri2021-03-30
| | | | typo fixed
* Add support for setting hyperlink display & tooltip (closes #790) (#794)James Allen2021-03-03
|
* lint issue fixed and new formula function: ATAN, AVERAGE, AVERAGEA, CONCAT, ↵xuri2021-02-15
| | | | CONCATENATE, COUNT, COUNTBLANK, MAX
* Fix #724, standardize variable naming and update unit testsxuri2020-11-11
|
* using POSIX directory separator in zip path with Windowsxuri2020-11-06
|
* Compatibility improvement: parse document core part (workbook) dynamicallyxuri2020-11-04
|
* Update conversion between integer types and unit testsxuri2020-10-23
|
* Fix #706, #713 improve AddPicture performance, fix missing worksheet when ↵xuri2020-10-18
| | | | rename with same names
* extend cell value load to support custom datetime format (#703)Artem Kustikov2020-10-04
| | | | | | | | | | | | | | | | | | | | | | | | | * 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>
* support ECMA-376 document standard encryption, ref #199xuri2020-09-02
|
* Resolve #199, init password protection spreadsheet supportxuri2020-09-01
|
* support case-sensitive doc parts to improve compatibilityxuri2020-07-09
|
* add limits for total columns, row and filename lengthxuri2020-05-29
|
generated by cgit v1.2.1 (git 2.18.0) at 2025-04-26 02:23:27 +0000