| Commit message (Collapse) | Author | Age | |
|---|---|---|---|
| * | excelize -> anyxcelizegetRowInterface | George Abbott | 2023-06-15 |
| | | |||
| * | This made stream writer support set the insert page break (#1393) | renxiaotu | 2022-11-16 |
| | | |||
| * | This closes #1391, escape XML characters to avoid with corrupt file | xuri | 2022-11-15 |
| | | | | | - Update and improve unit test coverage | ||
| * | Remove internal error log print, throw XML deserialize error | xuri | 2022-11-13 |
| | | |||
| * | This is a breaking change, remove partial internal error log print, throw ↵ | xuri | 2022-11-12 |
| | | | | | | | | XML deserialize error - Add error return value for the `GetComments`, `GetDefaultFont` and `SetDefaultFont` functions - Update unit tests | ||
| * | This closes #1379, cleanup stream writer temporary files by the `Close` function | xuri | 2022-10-26 |
| | | | | | | | - Fix error on inserting columns or rows on the worksheet which contains one cell merged cell range - Fix getting incomplete rich text cell value in some cases - Unit tests updated | ||
| * | Support get cell value which contains a date in the ISO 8601 format | xuri | 2022-10-24 |
| | | | | | | | | | - Support set and get font color with indexed color - New export variable `IndexedColorMapping` - Fix getting incorrect page margin settings when the margin is 0 - Update unit tests and comments typo fixes - ref #65, new formula functions: AGGREGATE and SUBTOTAL | ||
| * | This close #1373, fixes the incorrect build-in number format apply the result | xuri | 2022-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` | xuri | 2022-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 #1047, stream writer support set panes (#1123) | Harrison | 2022-10-11 |
| | | | | - New exported error `ErrStreamSetPanes` has been added | ||
| * | Stream writer support to set inline rich text cell (#1121) | charles.deng | 2022-10-10 |
| | | | | Co-authored-by: zhengchao.deng <zhengchao.deng@meican.com> | ||
| * | This closes #1358, made a refactor with breaking changes, see details: | xuri | 2022-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 #1354, stream writer will apply style in `RowOpts` for each cell ↵ | invzhi | 2022-09-21 |
| | | | | | | (#1355) Co-authored-by: Tianzhi Jin <tianzhi.jin@iglooinsure.com> | ||
| * | Using the specialized name in a variable and making comments clear | xuri | 2022-09-18 |
| | | | | | - Add JSON tags for `AppProperties`, `PivotTableOption` and `PivotTableField` structure | ||
| * | This closes #1330 update non existing sheet error messages (#1331) | davidborry | 2022-08-28 |
| | | |||
| * | This closes #1299 skip write nil values in SetRow (#1301) | Thomas Charbonnel | 2022-08-04 |
| | | | | Co-authored-by: Thomas Charbonnel <github@charbonnel.email> | ||
| * | adjust `ErrColumnNumber`, rename `TotalColumns` to `MaxColumns` and add new ↵ | MJacred | 2022-07-14 |
| | | | | | | constant `MinColumns` (#1272) Signed-off-by: Benjamin Lösch <loesch.benny92@gmx.de> | ||
| * | This update docs and tests for workbook encryption | xuri | 2022-05-31 |
| | | |||
| * | Format code, update documentation and remove exported variable `XMLHeaderByte` | xuri | 2022-03-24 |
| | | |||
| * | Update create style example, using a pointer of the structure instead of JSON | xuri | 2022-01-05 |
| | | |||
| * | This closes #1107, stream writer will create a time number format for time ↵ | xuri | 2021-12-31 |
| | | | | | | | type cells Unit test coverage improved | ||
| * | Export 7 errors so users can act differently on different type of errors | xuri | 2021-12-07 |
| | | |||
| * | Now support set row style in the stream writer | xuri | 2021-09-29 |
| | | |||
| * | This closes #833, closes #845, and closes #1022, breaking changes | xuri | 2021-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% | ||
| * | This closes #882, support set rows height and hidden row by stream writer | xuri | 2021-07-25 |
| | | |||
| * | - Support concurrency iterate rows and columns | xuri | 2021-07-05 |
| | | | | | | - Rename exported field `File.XLSX` to `File.Pkg` - Exported error message | ||
| * | This closes #409 Remove UTC timezone requirement from date.go (#853) | Alluuu | 2021-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 #838, fix wrong worksheet XML path of the stream writer in some case | xuri | 2021-05-14 |
| | | |||
| * | This closes #652, new SetColWidth API, support set column width in stream ↵ | xuri | 2021-05-10 |
| | | | | | writing mode, and export error message | ||
| * | Fixe issue generated file corrupted caused by incorrect default XML ↵ | xuri | 2021-04-30 |
| | | | | | namespace attributes | ||
| * | #826, support merge cell in streaming mode | xuri | 2021-04-28 |
| | | |||
| * | #65 fn: N, PERCENTILE.INC and T | xuri | 2021-03-30 |
| | | | | | typo fixed | ||
| * | #625, support setting formula for cell in streaming API | xuri | 2021-03-07 |
| | | |||
| * | lint issue fixed and new formula function: ATAN, AVERAGE, AVERAGEA, CONCAT, ↵ | xuri | 2021-02-15 |
| | | | | | CONCATENATE, COUNT, COUNTBLANK, MAX | ||
| * | This improves compatibility for worksheet relative XML path and multi rules ↵ | xuri | 2021-02-11 |
| | | | | | auto filter | ||
| * | Fix #724, standardize variable naming and update unit tests | xuri | 2020-11-11 |
| | | |||
| * | Compatible with Go 1.15, fix unit test failed on Windows and fixed #689 ↵ | xuri | 2020-08-15 |
| | | | | | potential race condition | ||
| * | Fix #576, serialize by fields order on stream flush | xuri | 2020-02-13 |
| | | |||
| * | Improve code coverage unit tests | xuri | 2019-12-29 |
| | | |||
| * | Stream to Excel table (#530) | Cameron Howey | 2019-12-29 |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | * Support all datatypes for StreamWriter * Support setting styles with StreamWriter **NOTE:** This is a breaking change. Values are now explicitly passed as a []interface{} for simplicity. We also let styles to be set at the same time. * Create function to write stream into a table * Write rows directly to buffer Avoiding the xml.Encoder makes the streamer faster and use less memory. Using the included benchmark, the results went from: > BenchmarkStreamWriter-4 514 2576155 ns/op 454918 B/op 6592 allocs/op down to: > BenchmarkStreamWriter-4 1614 777480 ns/op 147608 B/op 5570 allocs/op * Use AddTable instead of SetTable This requires reading the cells after they have been written, which requires additional structure for the temp file. As a bonus, we now efficiently allocate only one buffer when reading the file back into memory, using the same approach as ioutil.ReadFile. * Use an exported Cell type to handle inline styles for StreamWriter | ||
| * | Improve compatibility, fix workbook's rels ID calc error | xuri | 2019-12-23 |
| | | |||
| * | Improve code coverage unit tests | xuri | 2019-12-22 |
| | | |||
| * | Fix #523, add stream writer for generate new worksheet with huge amounts of data | xuri | 2019-12-10 |
 |
index : anyxcelize | |
| A fork of excelize to be able to write non-strings. |
| summaryrefslogtreecommitdiff |
path: root/stream_test.go