98f1a69903
support ECMA-376 document standard encryption, ref #199
4 years ago
4177c1585e
Resolve #199 , init password protection spreadsheet support
4 years ago
4e4baac3bc
using Mutex lock and update benchmark
4 years ago
c3e92a51d7
Compatible with Go 1.15, fix unit test failed on Windows and fixed #689 potential race condition
4 years ago
c922c32fb7
support parse and generate XML element namespace dynamic, fix #651
5 years ago
49257c5918
support case-sensitive doc parts to improve compatibility
5 years ago
48f19f60aa
support the row element without r attribute in the worksheet
5 years ago
c168233e70
speedup get cell value from shared string table
5 years ago
2efc7107ff
- transform the range to the matrix on the first arg of the formula
...
- typo fix
- reset cell with and height when insert picture into merged cell with autofit
5 years ago
48fc4c08a2
init formula calculation engine, ref #65 and #599
5 years ago
1fe660df64
- Resolve #485 use sheet index instead of ID
...
- added 3 internal function: getSheetID, getActiveSheetID, getSheetNameByID
5 years ago
0f2a905324
Performance improvements
5 years ago
3f89c6e979
remove ineffectual variable assignments and simplify code
5 years ago
6afc468a02
Resolve #451 , support create chart sheet
5 years ago
9e2318cefa
Resolve #470 , export Style structs to allow create the style for cells by given JSON or structure
5 years ago
2ccb8f62ed
Remove calculated properties to make recalculate formulas in some spreadsheet applications, such as Kingsoft WPS
5 years ago
ad883caa0f
Resolve #580 , revert commit 5ca7231ed4
5 years ago
5f5ec76740
Fix #551 , handle empty rows in streaming reading
5 years ago
09485b3f9f
Improve code coverage unit tests
5 years ago
1666d04559
optimization: checking error in unit tests
5 years ago
4e4a5b9b3e
Improve compatibility, fix workbook's rels ID calc error
5 years ago
7358dca436
Update comments for the xmlNewDecoder ( #542 )
5 years ago
4249dad8ea
Resolve #539 Merge branch 'v2'
...
# Conflicts:
# rows.go
# sheet.go
5 years ago
b1b3c0d151
Fix #539 Fixed error opening excel file created in encoding d… ( #540 )
...
* Fixed issue #539 Fixed error opening excel file created in encoding different from UTF-8, added logging of possible errors when decoding XML if the function does not provide exit with an error
* Added test for CharsetReader
* Fixed #discussion_r359397878
Discussion: https://github.com/360EntSecGroup-Skylar/excelize/pull/540#discussion_r359397878
* Fixed go fmt
* go mod tidy and removed unused imports
* The code has been refactored
5 years ago
402ad2f62b
Update XML namespace
5 years ago
8d6e431dcd
Resolve #521 , fix missing elements when parsing
5 years ago
bf9a835549
Reduce allocations when writing
...
Fix #494
If a row is full, don't bother allocating a new one, just return it.
Use the last populated row as a hint for the size of new rows.
Simplify checkSheet to remove row map
5 years ago
8922f65978
Combine functions:
...
workBookRelsWriter, drawingRelsWriter into relsWriter;
drawingRelsReader, workbookRelsReader, workSheetRelsReader into relsReader;
addDrawingRelationships, addSheetRelationships into addRels
5 years ago
9c70d0ac86
Documentation updated, Go 1.10+ required
6 years ago
cbe919fdf6
New feature: sparkline supported
6 years ago
35e485756f
Resolve #217 , new function add VBA project supported.
6 years ago
54def7eaad
Add TIF, TIFF format images and more detailed error information when open the encrypted file
6 years ago
b1f632d408
Resolve #393 , upgrade Go module to v2
6 years ago
0660f30cdd
godoc update and typo fixed
6 years ago
a88459d5f1
add unit tests to functions
6 years ago
f2df344739
Resolve #369,#370
...
add error return value
exported functions:
GetMergeCells
ProtectSheet
UnprotectSheet
UpdateLinkedValue
GetMergeCells
SetSheetVisible
inner functions:
workSheetReader
copySheet
6 years ago
40ff5dc1a7
refactor: handler error instead of panic,
...
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
6 years ago
dc01264562
Huge refactorig for consistent col/row numbering ( #356 )
...
* Huge refactorig for consistent col/row numbering
Started from simply changing ToALphaString()/TitleToNumber() logic and related fixes.
But have to go deeper, do fixes, after do related fixes and again and again.
Major improvements:
1. Tests made stronger again (But still be weak).
2. "Empty" returns for incorrect input replaces with panic.
3. Check for correct col/row/cell naming & addressing by default.
4. Removed huge amount of duplicated code.
5. Removed ToALphaString(), TitleToNumber() and it helpers functions at all,
and replaced with SplitCellName(), JoinCellName(), ColumnNameToNumber(), ColumnNumberToName(), CellNameToCoordinates(), CoordinatesToCellName().
6. Minor fixes for internal variable naming for code readability (ex. col, row for input params, colIdx, rowIdx for slice indexes etc).
* Formatting fixes
6 years ago
f66212da9b
Resolve #106 , #294 performance optimization for add hyperlink
6 years ago
1aed1d744b
Resolve #274 , performance optimization for add images, charts and shapes
6 years ago
1427027e38
Resolve #235 , performance optimization for add comments ( #347 )
6 years ago
0072bb7310
resolve the issue corrupted xlsx after deleting formula of cell, reference #346
6 years ago
725c1a0c40
New feature: File.DuplicateRowTo() duplicate row to specified row position.
...
DuplicateRowTo() is similar to DuplicateRow() but copies specified row not just after specified source row
but to any other specified position below or above source row.
Also I made minor modifications of tests: using filepath.Join() instead of direct unix-way paths strings
to avoid possible tests fails on other OS.
6 years ago
034de7acd8
Resolve #318 , add new functions and
6 years ago
fabd9d013f
README updated
6 years ago
9a6f66a996
New feature: the function `SearchSheet` now support regular expression, relate pull request #316
6 years ago
7b7ca99f5d
Duplicate row ( #317 )
...
* go mod tidy applied
* File.DuplicateRow() method added
6 years ago
3ca3156d45
Merge pull request #313 from sairoutine/feature/get_merge_cells
...
Add GetMergeCells
6 years ago
3012df08eb
Add GetMergeCells
6 years ago
b89f75c896
Add new logo for excelize
6 years ago
1c45425f12
resolve #276 , add OfficeOpenXML-XMLSchema-Strict mode support
6 years ago
3e004d900b
Comments style changed.
6 years ago
13a9769cc5
Comments style changed.
6 years ago
2f146c923c
Comments style changed.
6 years ago
b4a6e61ec3
Fix golint errors under confidence 0.1
6 years ago
ec37b114c3
Fixes #256 and format document.
7 years ago
d6468fc114
- Initialize theme support;
...
- RGBA, HSL color convert has been added;
- go test updated
7 years ago
9e463b4614
- Add error return value for functions: `AddChart()`, `AddComment()`, `AddPicture()`, `AddShape()`, `AddTable()` and `SetConditionalFormat()`
...
- go test has been updated
7 years ago
e8961f0aff
- Bugfix: set font family not works, relate issue #222 ;
...
- Remove useless function `replaceWorkSheetsRelationshipsNameSpace()`;
- Make test cases use strict error checking
7 years ago
38ad20efc1
save bytes on memory instead of string
7 years ago
52b1a8e896
- Function `SetCellValue()` time.Duration support added, relate issue #176 ;
...
- go test updated
7 years ago
96b3e1ea74
Bugfix: corrupted xlsx after write operation, relate issue #152 .
...
Signed-off-by: Ri Xu <xuri.me@gmail.com>
7 years ago
a4ffb4fbfc
Merge pull request #141 from WingGao/wing
...
fix OpenReader no sheet error
7 years ago
f10ee929d0
- Bugfix: use sheet name in func `AddPicture`, relate issue #142 ;
...
- godoc updated
7 years ago
48b8bac126
fix OpenReader no sheet error
7 years ago
8077732dff
Bugfix: read sheet name error, relate issue #137
...
Signed-off-by: Ri Xu <xuri.me@gmail.com>
7 years ago
9b5b74d480
Performance optimization, use the array index instead of the value in range.
7 years ago
905be463ed
Improve code readability.
7 years ago
f05f799f8d
- API changed, use worksheet name instead of "sheet" + index, related issue #25 , #43 , #47 , #51 , #89 , #101 , #116 and #120 .
...
- go test updated
7 years ago
6aa59a1af2
- Init insert/remove column/row support. Relate issue #77 and #82 ;
...
- Readme and go test updated
8 years ago
38df838598
Bugfix: unable to read the value of the merged cell, relate issue #78
8 years ago
654a676d93
- New function `NewStyle()` added and function `SetCellStyle()` has been exported, relate issue #72 ;
...
- go test and go doc updated
8 years ago
e05867a033
Function `GetCellValue()` performance improvement by avoid repeating deserialization, relate issue #70 .
8 years ago
555e2ba9a8
- Make function `TitleToNumber()` exportable, note that function `ToAlphaString()` return value calculation changes, get more info from go doc. Relate issue #63 ;
...
- Readme and go doc updated
8 years ago
35841caaf1
- Function `formattedValue()` performance improvement by avoid repeating deserialization, relate issue #64 ;
...
- Make function `ToAlphaString()` exportable, relate issue #63
8 years ago
db4aff04fd
- Handle pre-defined number format set of cell when set cell value with `time.Time` data type, related issue #62 ;
...
- go doc updated
8 years ago
efff54ccde
- Fixed coordinate parse error in function `SetCellStyle()`, relate issue #60 ;
...
- Simplified code
8 years ago
d372bb977f
Priority cell style, when the cell and the column at the same time with the style attribute. Relate issue #54 and #56 .
8 years ago
e41ee8a124
Set cell support column style predefined detection, relate issue #54 .
8 years ago
dea57dd0ae
Code optimize.
8 years ago
8fbab47444
- Formatted cell data support, fix issue #48 ;
...
- Function `SetCellValue()` support `time.Time` data type parameter, relate issue #49 ;
- go doc and go test updated
8 years ago
8fd061b98f
- Fix SheetCount count error;
...
- Optimize deserialization operations;
- README updated, add go version required notice
8 years ago
330c7a0925
Performance enhancements, remove redundant XML element checking logic. Relate issue #29 . The benchmark report of the current version of this library is shown on the wiki page.
8 years ago
bee487c445
Leading space(s) character in cell value detection added. Related issue #32 .
8 years ago
de6e075713
Performance improvement
8 years ago
5384756d64
- Complete the element `sheetFormatPr` struct definition;
...
- Partial logic performance optimization, use pointer reference instead of a pass the variable value;
- Add comments for content types struct definition;
- Update go test `TestSetBorder` section
8 years ago
1f73f08185
- New feature: border setting support (Related issue #21 );
...
- Function parameter code is simplified;
- Fix element `Tint` value parsing error in worksheet;
- Update go test
8 years ago
bd817ea890
Put path back into a file
8 years ago
e8ba09d0c5
io.Reader not io.ReaderAt
8 years ago
d9f4a2f154
Standardize input and output
8 years ago
0833a9d5da
- Improved performance when reading large files, call Token to read tokens one by one instead Unmarshal. Related issue #20 ;
...
- Fix go test typo;
- Update README
8 years ago
a1060e779e
Make functions: `SetCellValue`, `SetCellInt`, `SetCellHyperLink`, `SetCellFormula`, `GetCellValue` and `GetCellFormula` to support the merged cells.
8 years ago
4a9b39afc6
- Add hyperlink and set formula support for cell support;
...
- Character limits for cells added;
- Update go test and fix typo
8 years ago
52796f6e58
Format commants, break comments after 80 characters.
8 years ago
f05df2a018
- New function `SetSheetName` and `SetColWidth` added, support rename sheet and set column width;
...
- Add escape characters of sheet name;
- Update go test and fix typo
8 years ago
a99f0227b0
- New function `AddPicture()` added, support to add picture into excel cell;
...
- go test updated;
- fix typo and `gofmt -s` formatted
8 years ago
670a587912
Add setter for default cell value
...
SetCellStr escapes the value in a cell so the excel sheet cannot use the value in formulas.
SetCellDefault accepts a string value and sets it to a cell as a raw value without escaping it
8 years ago
9e8d36ce59
- Performance improvement, remove `replaceRelationshipsID` and `workBookCompatibility` functions;
...
- New functions `GetActiveSheetIndex`, `GetSheetName` and `GetSheetMap` added.
8 years ago
f958f05a3b
- Fix issue: sheet protection and conditional formatting proprietary missing after save;
...
- Update workbook and sheet relationships and self-close tag replacement hack functions
8 years ago
a16d2ec83b
Change complete rows logic to fix call `SetCellValue`makes file corruption in some case.
8 years ago
xuri