6afc468a02
Resolve #451 , support create chart sheet
5 years ago
1d87da57ec
Resolve #492 , init support for insert and remove page break
5 years ago
ad883caa0f
Resolve #580 , revert commit 5ca7231ed4
5 years ago
e51aff2d95
Resolve #570 , flat columns for the column's operation
5 years ago
5ca7231ed4
optimize code and comments: use println errors instead of panic
5 years ago
09485b3f9f
Improve code coverage unit tests
5 years ago
4e4a5b9b3e
Improve compatibility, fix workbook's rels ID calc error
5 years ago
ae2865d923
Improve code coverage unit tests
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
a526e90404
Fix #426 , handle empty workbook view
5 years ago
402ad2f62b
Update XML namespace
5 years ago
8d6e431dcd
Resolve #521 , fix missing elements when parsing
5 years ago
7965e1231b
Resolve #146 , make the GetRow function read data as streaming. Ref: #382 , #515
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
5e418ebd66
Resolve #507 , add the new function `DeleteDefinedName`
5 years ago
e7581ebf3e
Fix corrupted Excel file issue #413
5 years ago
2e791fa433
Optimize code of Getting/Setting Page Margins
5 years ago
2d21b5b50f
Added accessors for Getting/Setting Page Margins ( #497 )
...
* Added accessors for Getting/Setting Page Margins
* Added test cases
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
faaaa52cb8
Get sheet names based on index
...
SheetID only seems to indicate the file name for the sheet.
Check the sheets list based on index instead. Reordering sheets
in Excel changes the order they appear in that list.
Fixes #457
6 years ago
cbe919fdf6
New feature: sparkline supported
6 years ago
b5f7d4a78e
Merge pull request #447 from dongkai16z/master
...
Fix #443
6 years ago
0c9e5137e3
Fix #442
6 years ago
53e653f28e
Fix #443
6 years ago
e14d2febc8
Resolve #432 , supplement the function of SetPageLayout
...
SetPageLayout support to set fit to width and height
6 years ago
8b2d4cb697
New feature: group and ungroup sheets support
...
New functions `GroupSheets` and `UngroupSheets` added
Refactor sheet index calculation
6 years ago
dc8210d4a7
Update GoDoc and typo fixed
6 years ago
a335be7e4e
New functions: SetDefinedName and GetDefinedName added
6 years ago
421f945f51
Fixed #418 , #420 , #421 , init adjust calculation chain support
...
Update testing case
6 years ago
f91f548614
Resolve #404 , get sheet map by target rels.
6 years ago
69b38ddcd6
Resolve #394 , init set header and footer support
6 years ago
01a418bda8
Resolve #392 , compatible with strict relations name space inspection
6 years ago
0660f30cdd
godoc update and typo fixed
6 years ago
0f9170a03b
Resolve #382 , rewrite prepareSheetXML to scale linearly ( #383 )
...
* 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
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
841ff4a03e
Fix out of range panic when removing formula.
...
Fix file corruption issue when deleting a sheet containing a formula.
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
2874d75555
Add benchmark for adding images to sheet ( #367 )
...
* Add benchmark for adding images to sheet
This should help track performance regressions in future changes.
* Only transform sheet name if necessary
6 years ago
40ea8eb014
resolve #360 , fix axis parse issue when add / get pictures;
...
typo fixed and go test updated
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
0072bb7310
resolve the issue corrupted xlsx after deleting formula of cell, reference #346
6 years ago
81948d9e1e
The function SetPageLayout support set paper size
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
9b8baf75ad
Add RegSearchSheet ( #316 )
6 years ago
e728ff1498
Fixes #308 , refactor `NewSheet()`, `DeleteSheet()`, `SetActiveSheet()` and `GetActiveSheetIndex()`
6 years ago
81b43da7b6
Fix comments according to best practices by effective go
6 years ago
b89f75c896
Add new logo for excelize
6 years ago
1bb59f75ea
resolve #297 , fix GetSheetMap() failed
...
Change-Id: I585a4a017867b89bd39cb6e711467a46eaa757be
6 years ago
51857a217d
New function `UnprotectSheet()` has been added
6 years ago
4dbc78ce0a
resolve #273 new feature: protect sheet support
...
new feature: protect sheet support, relate issue #273
6 years ago
e2e58a3a44
New function: `SearchSheet()`, relate issue #277
6 years ago
1c45425f12
resolve #276 , add OfficeOpenXML-XMLSchema-Strict mode support
6 years ago
204139739a
Merge branch 'master' into master
6 years ago
3e004d900b
Comments style changed.
6 years ago
13a9769cc5
Comments style changed.
6 years ago
2f146c923c
Comments style changed.
6 years ago
6ced438f39
New function `AddPictureFromBytes()` has been added, this resolve #259 and close #271 .
6 years ago
b4a6e61ec3
Fix golint errors under confidence 0.1
6 years ago
ec37b114c3
Fixes #256 and format document.
7 years ago
a3571ee39b
Bugfix: create worksheet cause file issue. Relate issue #249 .
7 years ago
4a1b406456
CopySheet() using reflect instead of encoding/gob
...
Use github.com/mohae/deepcopy to deep copy worksheets instead of the
internal deepcopy function that was using encoding/gob serialization and
deserialization.
Rationale:
1/ using `encoding/gob` is much slower than
[`mohae/deepcopy`](https://github.com/mohae/deepcopy/ )
2/ When building an application this implementation of `deepcopy` drags
the `encoding/gob` package into the binary. And this package is much
bigger than `mohae/deepcopy` (which only depends on `time` and `reflect`).
```
$ LC_ALL=C stat -f "%6z %N" $(go env GOPATH)/pkg/$(go env GOOS)_$(go env GOARCH)/github.com/mohae/deepcopy.a $(go env GOROOT)/pkg/$(go env GOOS)_$(go env GOARCH)/encoding/gob.a
10508 .../pkg/darwin_amd64/github.com/mohae/deepcopy.a
541818 .../pkg/darwin_amd64/encoding/gob.a
```
7 years ago
ccdefb3b16
Documentation:
...
* Add information about return value of NewSheet()
* Minor documentation language fixes
Samples:
* Added sample go file for dumping a XLSX file to the console
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
d96440edc4
- Performance optimization 20% faster, 14% memory savings on set cell values;
...
- Using the canonical syntax in issue template and contributing guide;
- go test has been updated
7 years ago
167554bfec
Improve unit testing, remove redundant code.
7 years ago
38ad20efc1
save bytes on memory instead of string
7 years ago
200437d778
Fix document typo.
7 years ago
a9c7d6637c
- Support to set the positioning of a picture, relate issue #214 ;
...
- go test and godoc has been updated
7 years ago
d65b30055d
- Update the function `NewSheet()` to handle when already exists a worksheet of the same name, relate pull request #196 ;
...
- go test and godoc has been updated
7 years ago
06e54bf1c6
Readme and godoc has been updated.
7 years ago
749d12eece
- Fix `DeleteSheet()` make broken file, relate issue #165 ;
...
- godoc updated
7 years ago
f10ee929d0
- Bugfix: use sheet name in func `AddPicture`, relate issue #142 ;
...
- godoc updated
7 years ago
ebafbdde73
Bugfix: use sheet name in func `AddChat`, relate issue #138
...
Signed-off-by: Ri Xu <xuri.me@gmail.com>
7 years ago
905be463ed
Improve code readability.
7 years ago
b7b937a8a3
godoc updated.
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
1ec2661dda
Bugfix: deep copy issue with function `CopySheet()`, relate PR #108 .
8 years ago
02728de4d2
Conut and trim sheet name in UTF-8
8 years ago
6626a26f7b
Simplify code and update unit tests.
8 years ago
308776e350
Optimize code, go test and godoc updated.
8 years ago
bbed2f6dc9
- Init create or remove panes support;
...
- go test updated
8 years ago
3b2c80ddc3
Trim blank cells which created by `completeCol()`, relate issue #81
8 years ago
4a17c14399
SHEET.GO: Fix small typo
...
Adds a '{' to the example for sheet.GetSheetMap()
Signed-off-by: Mark Stenglein <mark@stengle.in>
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
a9f671d98f
- New functions: `GetSheetVisible()` and `GetRowVisible()` added, relate issue #61 ;
...
- go test updated
8 years ago
c89d842352
Init auto filter support, relate issue #59 .
8 years ago
dea57dd0ae
Code optimize.
8 years ago
d93a156355
Initialize comments support & go test updated.
8 years ago
7f30a6c943
- Initialize shape support: new function `AddShape()` added. Relate issue #38 ;
...
- Drawing `nvPicPr` element ID property calculation changed;
- go test updated
8 years ago
2868bd3ec9
- New function `HideSheet()` and `UnhideSheet()` added;
...
- go test updated
8 years ago
c7e277a07a
- New function `CopySheet()` added, relate issue #33 ;
...
- Typo fixed;
- go test updated
8 years ago
b4ed9cc40f
New function `GetSheetIndex()` added, relate issue #25 ;
...
Fix return index error in function `GetSheetMap()`;
Fix return worksheet name error in function `GetSheetName()`;
go test updated
8 years ago
8fd061b98f
- Fix SheetCount count error;
...
- Optimize deserialization operations;
- README updated, add go version required notice
8 years ago
02b81b7efe
- Get an images in a cell supported, new function `GetPicture` added;
...
- go test updated
8 years ago
0d3452fbe2
- Delete sheet from workbook support, related issue #30 ;
...
- go test updated
8 years ago
de6e075713
Performance improvement
8 years ago
bd5b033b02
Support set work sheet background image.
8 years ago
81146218c7
Update README, godoc and fix typo.
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
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
c5cc500b88
- Fix issue: pivot cache and extending spreadsheetML missing;
...
- Compatibility improved: relationship namespace in `workbook.xml` has been changed (`xmlns:mc`, `xmlns:x15` and `mc:Ignorable` added)
8 years ago
b84bfa7eab
- Update maximum 31 characters allowed in sheet title;
...
- Fix issue XML tag `headerFooter` and `sheetPr` element self-close errors cause file corruption;
- Fix issue `Section` and `Pane` element order make file corruption in some case;
- Change sheet `rId` calculation method in `/xl/workbook.xml`, fix makes file corruption in some case;
- Compatibility improved: add `xlsxTabColor` struct and some XML element for worksheet
8 years ago
a08c8eb1ae
- Fix issue comments missing after save;
...
- Update import PKG syntax in struct;
- Update test XLSX file (include table, charts, functions, comments and hyperlink on Sheet1)
8 years ago
ddeed48fc1
- Fix issue background image and table missing after save;
...
- Update test template for this fix
8 years ago
6e1475a242
Fix hyperlink missing after save issue and update completion row element logic to enhance compatibility.
8 years ago
6185cd577d
Update go test.
8 years ago
75abc628fe
Update godoc of package.
8 years ago
2e8fa2d39c
Use conjunction with strings.Map to split Axis and update godoc.
8 years ago
50863294f9
Fix issue #2 change project to object-oriented style and update readme file.
8 years ago
956a4627d1
Fix issue #4 use builtin `map` instead of home-built.
8 years ago
9c3a24d5c3
xml marshal without indent and use buffer in string concatenation.
8 years ago
192af02a40
Format code with golint rules
9 years ago
3c4ad28db7
- Get cell value support
...
- Optimisation code use fmt package
- Update README
- Remove useless function
9 years ago
a9d3ee2869
Init commit.
9 years ago
xuri