Excelize

Fork

This closes #744, the `Save`, `Write` and `WriteTo` function accept saving options

This closes #1293, add new function `GetColStyle`

- Fix generate workbook corruption after insert cols/rows in some case
- Update unit tests
- Update dependencies module

Fix get image content was empty after inserting image

This closes #1338, fix apply AM/PM format issue

This closes #1323, an error will be returned when set the not exist style ID

This is a breaking change closes #1332 (#1333)

This use `InsertRows` instead of `InsertRow`, and using `InsertCols` instead of `InsertCol`

This closes #1330 update non existing sheet error messages (#1331)

This closes #827, add new functions `GetDataValidations` and `GetConditionalFormats` (#1315)

Signed-off-by: chenliu1993 <13630583107@163.com>

This closes #1247, add new function `SetSheetCol` for set worksheet column values (#1320)

Signed-off-by: cdenicola <cooper.denicola@instabase.com>
Co-authored-by: cdenicola <cooper.denicola@instabase.com>

This closes #1290 and closes #1328

- Add new smooth field in chart format parameter, support specify if smooth line chart
- Fix decimal number format round issue with build-in number format

This made library allowing insert EMZ and WMZ format image

- Update dependencies module

Support encrypt workbook with password #199 (#1324)

This closes #849, add new function `DeleteComment` for delete comment (#1317)

- Update unit tests for the delete comment
- Add 3 errors function for error messages

This closes #1319, fix calculate error for formula with negative symbol

- Update unit test and comment for the functions

This closes #1244 and closes #1314, improving the compatibility with Google Sheet

- Format code with `gofmt`

This closes #1312, #1313, fix number format issue

- Add supported options in the docs of the functions `SetSheetPrOptions` and `GetSheetPrOptions`
- Add go1.19 unit test settings, and made the test case compatible with go1.19
- Update dependencies module

This closes #1296, add new function `GetRowOpts` for stream reader (#1297)

- Support get rows properties by `GetRowOpts` function
- New exported constant `MaxCellStyles`

This reduces memory usage and speedup the `AddComment` function (#1311)

By load only once for existing comment shapes, improving performance for adding comments in the worksheet

Add new exported `ColorMappingType` used for color transformation

Using `ColorMappingType` color transformation types enumeration for tab color index, ref #1285

This closes #1299 skip write nil values in SetRow (#1301)

Co-authored-by: Thomas Charbonnel <github@charbonnel.email>

This closes #1298, fix doc properties missing after creating new worksheet

This closes #1283, support set and get color index, theme and tint for sheet tab

This commit renames `TabColor` into `TabColorRGB` (but keeps an alias for backwards compatibility), as well as adds support for more tab color options (Theme, Indexed and Tint).

Signed-off-by: Thomas Charbonnel <github@charbonnel.email>

Fix potential file corrupted and change worksheet name case-insensitive

- Using sheet ID instead of sheet index when delete the cell in calculation chain
- Update documentation for exported functions
- Using `sheet` represent the sheet name in the function parameters

Optimizing line breaks for comments (#1281)

Fix potential file corrupted when changing cell value or the col/row

- Remove shared formula subsequent cell when setting the cell values
- Support adjust table range when removing and inserting column/row

adjust `ErrColumnNumber`, rename `TotalColumns` to `MaxColumns` and add new constant `MinColumns` (#1272)

Signed-off-by: Benjamin Lösch <loesch.benny92@gmx.de>

This fix potential panic and file corrupted

- Fix the panic when set or get sheet view options on the sheet without views options
- Fix generated workbook corruption caused by empty created or modified dcterms in the document core properties
- Update the unit tests

This closes #1262, support for dependence formulas calculation

- Add export option `MaxCalcIterations` for specifies the maximum iterations for iterative calculation
- Update unit test for the database formula functions

This closes #1269, made the `NewStreamWriter` function case insensitive to worksheet name

Co-authored-by: xiangyz <xiangyz@dustess.com>

ref #65, new formula function: DGET