da0d2ffbb6
Fix #533 , add support overlapped mergecells
5 years ago
aa7eadbffe
fix go lock
5 years ago
2e791fa433
Optimize code of Getting/Setting Page Margins
5 years ago
810139f5fc
solve ending space missing
5 years ago
3280e1b686
Allow access to more formula attributes in SetCellFormula ( #484 )
...
* Allow access to more formula attributes in SetCellFormula
Make SetCellFormula variadic to not break API.
The new arguments are option arguments in which the type of
the formula and the ref attribute may be set.
These need to be set for an array formula to work.
* Add TestWriteArrayFormula to test optional parameters of SetCellFormula
TestWriteArrayFormula writes a document to the test directory that
contains array formulas that are used to calculate standard deviations.
The file also contains values calculated by the Go testcase, so the
results can be verified. It should be tested, if the array formula
works (i.e. shows a number, not an error) and that the values calculated
by the formula and those calculated by Go are the same.
5 years ago
8922f65978
Combine functions:
...
workBookRelsWriter, drawingRelsWriter into relsWriter;
drawingRelsReader, workbookRelsReader, workSheetRelsReader into relsReader;
addDrawingRelationships, addSheetRelationships into addRels
5 years ago
64809db2c9
add missing error check in SetSheetRow()
5 years ago
ac395a60ed
SetCellValue: use fmt.Sprint(v) instead of fmt.Sprintf("%v", v)
...
Because that does the same thing, but without having to parse a format
string.
Signed-off-by: Olivier Mengué <dolmen@cpan.org>
6 years ago
9c70d0ac86
Documentation updated, Go 1.10+ required
6 years ago
821632cf89
Fix #424 , refactor merged cells adjuster
6 years ago
b45c4b094c
Add a check for maximum limit hyperlinks in a worksheet
...
typo fixed
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
c423617e9d
Check max length for SetCellStr and fix coordinate issue for MergeCell
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
70b1a29165
Use bitSize for float32 type numbers conversion, relate PR #361
6 years ago
b2c12d784e
SetCellFloat for floats with specific precision ( #361 )
...
This allows the user to set a floating point value into a
cell with a specific number of places after the decimal.
Closes #357
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
0072bb7310
resolve the issue corrupted xlsx after deleting formula of cell, reference #346
6 years ago
fabd9d013f
README updated
6 years ago
ef334ee658
fix issue #290
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
aaced358f1
- Initialize shared formula types support, relate issue #227 ;
...
- go test and godoc has been updated
7 years ago
564ebe48dd
- Fix `checkCellInArea()` index out of range when merged cell ref is single coordinate, relate issue #206 ;
...
- go test updated;
- Repository icon for SourceTree has been added
7 years ago
770026e956
- New function `SetSheetRow()` has been added for support write whole line at once, relate issue #96 and #194 ;
...
- go test and godoc updated;
- Note that this function performance has not been tested
7 years ago
b25ec6e9d3
xlsx.SetCellValue() now supports bool value
7 years ago
317ef65381
make SetCellStyle quicker by skipping conversions in checkCellInArea, and skipping area checks when we are sure the cell can't be before or past the current row/col
...
Signed-off-by: Matthieu Bresson
7 years ago
52b1a8e896
- Function `SetCellValue()` time.Duration support added, relate issue #176 ;
...
- go test updated
7 years ago
21214a514d
Rename import path to github.com/360EntSecGroup-Skylar/excelize
7 years ago
f10ee929d0
- Bugfix: use sheet name in func `AddPicture`, relate issue #142 ;
...
- godoc updated
7 years ago
b4ffa8ce48
- Add unsigned integer data type support, related issue #136 ;
...
- go test and godoc updated
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
e820388d70
Handle coordinate parse exception, relate issue #122 .
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
574a6b20d1
Golang 1.9 compatible, fix issue #111
7 years ago
a8cf38ebd5
- New function `GetCellHyperLink()` added, relate issue #98 ;
...
- go test added
8 years ago
88d10ff27b
Fix round-off error in representation of date and time values
8 years ago
308776e350
Optimize code, go test and godoc updated.
8 years ago
5a4870d1cf
Add extra argument "Linktype" to SetCellHyperLink
...
it support "External" and "Location"
Signed-off-by: Youngwan Kim <y103.kim@gmail.com>
8 years ago
8493fea373
- Add number format code with unicode values, relate issue #86 ;
...
- godoc updated
8 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
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
dea57dd0ae
Code optimize.
8 years ago
66349f8ec0
Handle number formats out of built-in range exception by returning raw value, relate issue #50 .
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
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
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
c0a3020886
Support create merge cell.
8 years ago
9559f454a7
Fix issue #17 , update README 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
30d0a2f40a
- New function `GetCellFormula` added;
...
- Fix `GetCellValue` causes panic in some particular situation issues;
- Go test updated
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
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
xuri