xuri
49257c5918
support case-sensitive doc parts to improve compatibility
2020-07-09 01:24:11 +08:00
xuri
15fd56853f
Update docs and typo fixed
2020-06-22 00:14:56 +08:00
xuri
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
2020-05-21 22:57:58 +08:00
xuri
98221a332f
Merge pull request #410
2020-05-17 17:36:53 +08:00
6e90fa6b1d
Replace bytes.NewReader(stringToBytes(s)) with strings.NewReader(s) ( #610 )
2020-04-09 00:49:13 +08:00
xuri
66d0272f6a
Resolve #172 , init rich text support
2020-04-06 00:23:27 +08:00
xuri
0f2a905324
Performance improvements
2020-04-05 13:51:00 +08:00
xuri
6afc468a02
Resolve #451 , support create chart sheet
2020-03-28 23:47:26 +08:00
xuri
ad883caa0f
Resolve #580 , revert commit 5ca7231ed4
2020-02-19 00:08:10 +08:00
xuri
e51aff2d95
Resolve #570 , flat columns for the column's operation
2020-02-07 00:53:38 +08:00
xuri
cbc3fd21b7
Resolve #455 , init delete picture from spreadsheet support
2020-01-22 01:08:18 +08:00
xuri
5f5ec76740
Fix #551 , handle empty rows in streaming reading
2019-12-31 01:01:16 +08:00
xuri
09485b3f9f
Improve code coverage unit tests
2019-12-29 16:02:31 +08:00
xuri
ae2865d923
Improve code coverage unit tests
2019-12-22 00:02:09 +08:00
xuri
4249dad8ea
Resolve #539 Merge branch 'v2'
...
# Conflicts:
# rows.go
# sheet.go
2019-12-20 01:00:15 +08:00
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
2019-12-20 00:30:48 +08:00
xuri
eb520ae277
Improve compatibility for charts
2019-09-26 22:28:14 +08:00
xuri
a34d3b8c86
Compatibility improvement
2019-09-24 21:53:19 +08:00
xuri
8922f65978
Combine functions:
...
workBookRelsWriter, drawingRelsWriter into relsWriter;
drawingRelsReader, workbookRelsReader, workSheetRelsReader into relsReader;
addDrawingRelationships, addSheetRelationships into addRels
2019-09-16 01:17:35 +08:00
xuri
0acb3ef968
Testing files updated
2019-09-02 21:52:55 +08:00
xuri
9c70d0ac86
Documentation updated, Go 1.10+ required
2019-08-11 00:36:14 +08:00
xuri
54def7eaad
Add TIF, TIFF format images and more detailed error information when open the encrypted file
2019-06-27 21:58:14 +08:00
xuri
9f8623047d
Optimize code, fix golint issues
2019-06-20 00:00:40 +08:00
xuri
b1f632d408
Resolve #393 , upgrade Go module to v2
2019-05-02 15:57:47 +08:00
xuri
0660f30cdd
godoc update and typo fixed
2019-04-20 14:57:50 +08:00
xuri
f2df344739
Resolve #369,#370
...
add error return value
exported functions:
GetMergeCells
ProtectSheet
UnprotectSheet
UpdateLinkedValue
GetMergeCells
SetSheetVisible
inner functions:
workSheetReader
copySheet
2019-04-15 11:22:57 +08:00
a94dcb9918
Do not save duplicate images
...
Adding the same image should create a drawing referencing the
already stored copy of the image.
Closes #359
2019-03-25 13:17:53 -05:00
xuri
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
2019-03-23 20:08:06 +08:00
xuri
677a22d994
resolve #366 fix image duplication
2019-03-22 14:37:59 +08:00
xuri
40ea8eb014
resolve #360 , fix axis parse issue when add / get pictures;
...
typo fixed and go test updated
2019-03-20 16:52:33 +08:00
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
2019-03-20 00:14:41 +08:00
xuri
f66212da9b
Resolve #106 , #294 performance optimization for add hyperlink
2019-02-26 14:21:44 +08:00
xuri
1aed1d744b
Resolve #274 , performance optimization for add images, charts and shapes
2019-02-25 22:14:34 +08:00
xuri
fabd9d013f
README updated
2019-01-01 13:20:14 +08:00
xuri
1c45425f12
resolve #276 , add OfficeOpenXML-XMLSchema-Strict mode support
2018-10-17 00:28:31 +08:00
xuri
3e004d900b
Comments style changed.
2018-09-14 00:58:48 +08:00
xuri
13a9769cc5
Comments style changed.
2018-09-14 00:44:23 +08:00
xuri
6ced438f39
New function `AddPictureFromBytes()` has been added, this resolve #259 and close #271 .
2018-09-14 00:24:49 +08:00
xuri
b4a6e61ec3
Fix golint errors under confidence 0.1
2018-09-12 15:47:56 +08:00
ce5b37a4ac
# fix : file close 没有关闭
2018-08-20 16:53:51 +08:00
xuri
ec37b114c3
Fixes #256 and format document.
2018-08-06 10:21:24 +08:00
xuri
79dfe1c307
GoDoc updated.
2018-07-13 17:40:47 +08:00
xuri
9e463b4614
- Add error return value for functions: `AddChart()`, `AddComment()`, `AddPicture()`, `AddShape()`, `AddTable()` and `SetConditionalFormat()`
...
- go test has been updated
2018-05-27 11:25:55 +08:00
38ad20efc1
save bytes on memory instead of string
2018-05-07 16:12:51 +08:00
Ri Xu
a9c7d6637c
- Support to set the positioning of a picture, relate issue #214 ;
...
- go test and godoc has been updated
2018-04-26 11:41:13 +08:00
Ri Xu
06e54bf1c6
Readme and godoc has been updated.
2018-03-06 10:36:12 +08:00
Ri Xu
7621927573
- Add a hyperlink to an image support for the function `AddPicture()`, relate issue #185 ;
...
- go test and document has been updated.
2018-02-03 15:02:37 +08:00
21214a514d
Rename import path to github.com/360EntSecGroup-Skylar/excelize
2017-11-16 11:07:39 +08:00
Ri Xu
f10ee929d0
- Bugfix: use sheet name in func `AddPicture`, relate issue #142 ;
...
- godoc updated
2017-10-31 16:33:36 +08:00
Ri Xu
ebafbdde73
Bugfix: use sheet name in func `AddChat`, relate issue #138
...
Signed-off-by: Ri Xu <xuri.me@gmail.com>
2017-10-20 14:40:57 +08:00
Ri Xu
905be463ed
Improve code readability.
2017-09-30 17:07:59 +08:00
Ri Xu
f05f799f8d
- API changed, use worksheet name instead of "sheet" + index, related issue #25 , #43 , #47 , #51 , #89 , #101 , #116 and #120 .
...
- go test updated
2017-09-13 22:00:33 +08:00
Ri Xu
6aa59a1af2
- Init insert/remove column/row support. Relate issue #77 and #82 ;
...
- Readme and go test updated
2017-07-24 10:26:02 +08:00
Ri Xu
20aae4e0e6
Repo URI changed.
2017-07-11 14:54:47 +08:00
Ri Xu
66e5d1fa80
API changed, use `NewFile()` instead of `CreateFile()` and use `SaveAs()` instead of `WriteTo()`.
2017-06-28 17:03:20 +08:00
Ri Xu
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
2017-06-27 17:53:06 +08:00
Ri Xu
efff54ccde
- Fixed coordinate parse error in function `SetCellStyle()`, relate issue #60 ;
...
- Simplified code
2017-06-12 18:05:09 +08:00
Ri Xu
7c3f91ada4
Fix non-visual canvas properties ID calculator.
2017-05-25 11:15:38 +08:00
Ri Xu
dea57dd0ae
Code optimize.
2017-05-24 14:17:35 +08:00
Ri Xu
d93a156355
Initialize comments support & go test updated.
2017-05-13 13:28:21 +08:00
Ri Xu
7f30a6c943
- Initialize shape support: new function `AddShape()` added. Relate issue #38 ;
...
- Drawing `nvPicPr` element ID property calculation changed;
- go test updated
2017-04-30 20:03:43 +08:00
Ri Xu
46b8c46d91
- Initialize table support;
...
- go test updated
2017-04-28 15:49:41 +08:00
Ri Xu
219aadeb76
- Initialize char support, relate issue #31 ;
...
- Doc for function `GetRows()` updated, relate issue #43 ;
- Fix doc typo in `xmlContentTypes.go`;
- Default template updated;
- Readme updated;
- go test updated
2017-04-23 00:10:23 +08:00
Ri Xu
8fd061b98f
- Fix SheetCount count error;
...
- Optimize deserialization operations;
- README updated, add go version required notice
2017-04-01 13:56:39 +08:00
Ri Xu
7ceb4f21ad
Godoc updated.
2017-03-30 11:06:51 +08:00
Ri Xu
02b81b7efe
- Get an images in a cell supported, new function `GetPicture` added;
...
- go test updated
2017-03-28 21:18:06 +08:00
Ri Xu
de6e075713
Performance improvement
2017-03-12 20:38:26 +08:00
Ri Xu
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
2017-03-06 12:05:41 +08:00
Ri Xu
109d8adae3
Fix missing `oneCellAnchor` element after add picture in some cases.
2017-03-01 11:00:42 +08:00
Ri Xu
1e340aea40
Change function `AddPicture()` parameters to add add printing settings support. Related issue #27 .
2017-02-28 12:59:04 +08:00
Ri Xu
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
2017-02-12 19:03:24 +08:00
Ri Xu
bd5b033b02
Support set work sheet background image.
2017-01-24 18:29:02 +08:00
Ri Xu
81146218c7
Update README, godoc and fix typo.
2017-01-22 19:20:33 +08:00
Ri Xu
03234d6a25
Support add picture with offset and scaling.
2017-01-22 16:16:03 +08:00
Ri Xu
4a9b39afc6
- Add hyperlink and set formula support for cell support;
...
- Character limits for cells added;
- Update go test and fix typo
2017-01-19 14:05:32 +08:00
Ri Xu
52796f6e58
Format commants, break comments after 80 characters.
2017-01-18 16:05:01 +08:00
Ri Xu
a99f0227b0
- New function `AddPicture()` added, support to add picture into excel cell;
...
- go test updated;
- fix typo and `gofmt -s` formatted
2017-01-17 19:06:42 +08:00
xuri
Olivier Mengué