| Commit message (Collapse) | Author | Age |
| |
|
|
|
|
|
|
| |
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`
|
|
|
|
| |
This removed 3 exported functions: `TotalCols`, `CurrentCol` and `CurrentRow`
|
|
|
|
| |
Reduce allocation memory 20%, and 80% GC times for the row's iterator
|
| |
|
|
|
|
| |
Rename exported constants `NameSpaceDublinCoreMetadataIntiative` to `NameSpaceDublinCoreMetadataInitiative`
|
|
|
|
|
|
|
|
| |
- 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
|
| |
|
| |
|
| |
|
|
|
|
|
|
| |
- new formula function: YEARFRAC, ref #65
- update the codecov version
- remove unused variable
|
| |
|
|
|
|
|
|
| |
- Close spreadsheet and row's iterator required
- New options `WorksheetUnzipMemLimit` have been added
- Improve streaming reading performance, memory usage decrease about 93.7%
|
| |
|
|
|
|
|
|
|
| |
- Support text comparison in the formula, also ref #65
- `GetCellValue`, `GetRows`, `GetCols`, `Rows` and `Cols` support to specify read cell with raw value, ref #621
- Add missing properties for the cell formula
- Update the unit test for the `CalcCellValue`
|
| |
|
| |
|
|
|
|
|
| |
- Make unit test on Go 1.7
- API documentation updated
|
| |
|
|
|
|
|
|
|
| |
- support escaped string literal
- maximum character limit added
- fix missing preserve character in some case
Co-authored-by: xuri <xuri.me@gmail.com>
|
| |
|
|
|
|
| |
safety
|
| |
|
|
|
|
|
| |
- Rename exported field `File.XLSX` to `File.Pkg`
- Exported error message
|
|
|
|
| |
internal function `getSheetNameByID`
|
| |
|
| |
|
|
|
|
| |
CONCATENATE, COUNT, COUNTBLANK, MAX
|
| |
|
|
|
|
| |
with nil
|
|
|
|
|
| |
* fix UT-generated file names to be ignored
* fix cell value load with invalid number format ID
* fix PR issues
|
| |
|
|
|
|
| |
NewSheet in some case, fix panic on formatted value with no built-in number format ID
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
* 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>
|
|
|
|
| |
unit test update and typo fixed
|
|
|
|
| |
potential race condition
|
| |
|
| |
|
|
|
|
|
| |
- Allow empty filter, data, and rows in the pivot table
- Add more test case for pivot table
|
| |
|
|
|
|
| |
https://github.com/360EntSecGroup-Skylar/excelize/commit/5ca7231ed408ac264f509ff52b5d28ff4fbda757
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
|
|
|
|
|
| |
* #386 regression test added
* closes #386 string to bigint on GOARCH=386
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
* Rewrite prepareSheetXML to scale linearly
We don't need to backfill columns into every row for most purposes
Provided makeContiguousColumns for setting styles where we do
need it for a specific region.
Added a benchmark to monitor progress. For 50,000 rows this went
from about 11 seconds to 1 second. The improvements are more
dramatic as the row/column count increases.
* Assigning that row value was redundant
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
Exported functions:
SetCellStyle
InsertCol
RemoveCol
RemoveRow
InsertRow
DuplicateRow
DuplicateRowTo
SetRowHeight
GetRowHeight
GetCellValue
GetCellFormula
GetCellHyperLink
SetCellHyperLink
SetCellInt
SetCellBool
SetCellFloat
SetCellStr
SetCellDefault
GetCellStyle
SetCellValue
MergeCell
SetSheetRow
SetRowVisible
GetRowVisible
SetRowOutlineLevel
GetRowOutlineLevel
GetRows
Columns
SearchSheet
AddTable
GetPicture
AutoFilter
GetColVisible
SetColVisible
GetColOutlineLevel
SetColOutlineLevel
SetColWidth
GetColWidth
inner functions:
adjustHelper
adjustMergeCells
adjustAutoFilter
prepareCell
setDefaultTimeStyle
timeToExcelTime
addDrawingChart
addDrawingVML
addDrawingPicture
getTotalRowsCols
checkRow
addDrawingShape
addTable
|