• R/O
  • HTTP
  • SSH

excelize: 提交列表

Go language library for reading and writing Microsoft Excel™ (XLAM / XLSM / XLSX / XLTM / XLTX) spreadsheets

Rev. 时间 作者
a34c81e master v2 2023-03-20 10:17:28 ChantXu64

This closes #1448, speed up for checking merged cells (#1500)

478b528 2023-03-19 21:29:35 xuri

Breaking changes: changed the function signature for 2 exported functions

- Change
`func (f *File) AddPictureFromBytes(sheet, cell, name, extension string, file []byte, opts *GraphicOptions) error`
`func (f *File) AddPictureFromBytes(sheet, cell string, pic *Picture) error`
- Change
`func (f *File) GetPicture(sheet, cell string) (string, []byte, error)`
`func (f *File) GetPictures(sheet, cell string) ([]Picture, error)`

Co-authored-by: huangsk <645636204@qq.com>

7631fd0 2023-03-18 21:45:34 xuri

This closes #1499, support to set number format for chart data labels and axis

e394f01 2023-03-15 10:17:30 Rizki Putra

This update the return value for the `CalcCellValue` function (#1490)

- Using formula error string in the result of the `CalcCellValue` function
- Using the error message in the `CalcCellValue` function returns error
- Update unit tests

0d193c7 2023-03-14 01:58:20 xuri

This closes #1492, fix data bar min/max value doesn't work

dc3bf33 2023-03-04 01:07:04 xuri

Breaking change: changed the third parameter for the `AddFilter`

- Support to add multiple filter columns
- Remove the exported type `AutoFilterListOptions`
- Support to specify if show header row of the table
- Update unit tests and documents of the function

f707b2d 2023-03-01 14:25:17 张涛

This closes #1484, fix the formula calc result issue (#1485)

- Optimize variable name for data validation

65a53b3 2023-02-27 01:05:36 xuri

Breaking changes: replace the type `ShapeParagraph` with `RichTextRun`

- This removes the `Color` field from the type `Shape`, and uses the `Fill` instead of it
- Remove sharp symbol from hex RGB color
- Update unit tests

669c432 2023-02-24 01:18:10 Baris Mar Aziz

This fixes #756, made stream writer skip set cell value when got nil (#1481)

94e86dc 2023-02-22 23:46:36 xuri

This renamed conditional format type `iconSet` to `icon_set`

- Remove Minimum, Maximum, MinLength, and MaxLength fields from the type `ConditionalFormatOptions`
- Update unit tests and format code

f143dd5 2023-02-21 01:17:35 Shugo Kawamura

Support double-byte chars for formula functions LENB, RIGHTB and MIDB (#1478)

983cd76 2023-02-20 14:59:05 Shugo Kawamura

This closes #1476, support double-byte chars for formula functions LEFT,RIGHT, LEN and MID (#1477)

cb0c1b0 2023-02-19 01:18:11 xuri

Support specifies the values in second plot for the bar/pie of pie chart

- Upgrade dependencies package golang.org/x/image to 0.5.0
- Update unit tests

21ec143 2023-02-18 15:28:47 dependabot[bot]

Update dependencies package golang.org/x/net from 0.5.0 to 0.7.0 (#1475)

c2d6707 2023-02-17 21:03:46 xuri

This closes #1474, support set the format for the data series fill (solid fill)

- Breaking changes: remove the `Color` field in the `ChartLine` structure
- This support set the bubble size in a data series
- Unit test update and correct the docs of the function `GetSheetDimension`

ad90cea 2023-02-15 22:38:11 jaby

This closes #1469, fix cell resolver caused incorrect calculation result (#1470)

363fa94 2023-02-13 14:28:02 xuri

This closes #1468, checks the table name, and added a new error constant `ErrTableNameLength`

- XML Structure field typo fixed
- Update documentation for the `AddChart` function
- Update unit test

38f1317 2023-02-11 19:37:06 Josh Weston

This closes #1463, add new functions `SetSheetDimension` and `GetSheetDimension` (#1467)

753969d 2023-02-08 01:03:45 xuri

Support creating a conditional format with an "icon sets" rule

- Improvement compatibility for the worksheet extension lists
- Update unit test

3e24060 2023-02-07 01:08:11 xuri

This closes #1462 and closes #1464

- Support creating a conditional format with a "stop if true" rule
- Support set border color and create solid color for the color data bar
- Fix incorrect cell type when modifying string cell with the time number
- Update unit test for the add pivot table to avoid pivot table range overlap

1f69f6b 2023-02-05 02:30:38 xuri

Add support for insert BMP format images

- Add support for workbook function groups
- Update code and docs for the build-in currency number format
- Update unit tests

12645e7 2023-02-03 01:08:46 xuri

This fixes #1461, supports 0 row height and column width

- Increase max cell styles to 65430
- Add new exported error variable `ErrCellStyles`
- Update unit tests, support test under Go 1.20.x

85e0b6c 2023-02-01 01:11:08 xuri

Support to create of 17 kinds of fill variants styles

- Update the unit tests
- Update the `SetHeaderFooter` function parameters name
- Update document for the `SetDocProps` and `SetCellHyperLink` functions

be36b09 2023-01-26 11:35:13 Nathan Davies

This fixes #1457, reduce string concatenation when applying number format (#1459)

Co-authored-by: Nathan Davies <ndavies@turnitin.com>

1ab7a99 2023-01-25 13:22:28 Nathan Davies

This fixes #1455, pre generate strings months name for number format (#1456)

- Reducing string concatenation and string conversion between rune string data types

Co-authored-by: Nathan Davies <ndavies@turnitin.com>

917e6e1 2023-01-20 12:10:04 xuri

This roundup time value when a millisecond great than 500 to fix the accuracy issue

- Correction example in the documentation of set cell formula
- Rename the internal function `parseOptions` to `getOptions`
- Update unit tests

4f0025a 2023-01-13 01:05:46 xuri

This closes #1447, add support for strict theme namespace

- Support specify if applying number format style for the cell calculation result
- Reduce cyclomatic complexities for the OpenReader function

00c58a7 2023-01-12 01:14:38 Liron Levin

Fix panic caused by the workbook relationship part not exist (#1443)

- Check nil map in the getSheetMap function
- Update unit tests

14d7acd 2023-01-10 02:02:48 xuri

This fixes #1441, add copyright agreement statement on the LICENSE

5429f13 2023-01-08 01:23:53 xuri

This closes #1438, fix cell data type issue for formula calculation engine

- Update dependencies module
- Update unit tests

Show on old repository browser