excelize-formula

Commit Graph

Author	SHA1	Message	Date
xuri	9a6f66a996	New feature: the function `SearchSheet` now support regular expression, relate pull request #316	6 years ago
Veniamin Albaev	7b7ca99f5d	Duplicate row (#317 ) * go mod tidy applied * File.DuplicateRow() method added	6 years ago
r-uchino	9b8baf75ad	Add RegSearchSheet (#316 )	6 years ago
xuri	b04107c4a3	Resolve #311 , create 2D/3D area, stacked area, 100% stacked area chart support	6 years ago
xuri	3ca3156d45	Merge pull request #313 from sairoutine/feature/get_merge_cells Add GetMergeCells	6 years ago
sairoutine	3012df08eb	Add GetMergeCells	6 years ago
xuri	b89f75c896	Add new logo for excelize	6 years ago
q523591	51857a217d	New function `UnprotectSheet()` has been added	6 years ago
HcySunYang	4dbc78ce0a	resolve #273 new feature: protect sheet support new feature: protect sheet support, relate issue #273	6 years ago
covv	75edf1ac7d	Add testing case for the function `SearchSheet()`.	6 years ago
xuri	90bdd3632f	Fix the issue caused by missing tradition to strict conversion for `sharedStringsReader()`, relate issue #276	6 years ago
lizheao	2be4d45c62	feat: add new function and refactor writeto action * add new exported function to get Excel file content buffer * refactor the WriteTo function	6 years ago
xuri	6ced438f39	New function `AddPictureFromBytes()` has been added, this resolve #259 and close #271 .	6 years ago
xuri	a3571ee39b	Bugfix: create worksheet cause file issue. Relate issue #249 .	7 years ago
xuri	58a7b23d11	Merge pull request #246 from nad2000/retrieve-comments added retrieval of worksheet comments	7 years ago
xuri	d6468fc114	- Initialize theme support; - RGBA, HSL color convert has been added; - go test updated	7 years ago
Rad Cirskis	1a953b6601	added unit tests	7 years ago
Olivier Mengué	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
xuri	9e463b4614	- Add error return value for functions: `AddChart()`, `AddComment()`, `AddPicture()`, `AddShape()`, `AddTable()` and `SetConditionalFormat()` - go test has been updated	7 years ago
xuri	aaced358f1	- Initialize shared formula types support, relate issue #227 ; - go test and godoc has been updated	7 years ago
xuri	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
xuri	167554bfec	Improve unit testing, remove redundant code.	7 years ago
xuri	eb62256d16	Simplify testing code, add test case for outline functions and update the godoc.	7 years ago
xuri	e8961f0aff	- Bugfix: set font family not works, relate issue #222 ; - Remove useless function `replaceWorkSheetsRelationshipsNameSpace()`; - Make test cases use strict error checking	7 years ago
Ri Xu	3ca180f09c	Merge test cases and use strict error checking.	7 years ago
Ri Xu	934ecec1a9	- Set name of table support in `AddTable()`, relate issue #216 ; - godoc and go test has been updated	7 years ago
Ri Xu	a9c7d6637c	- Support to set the positioning of a picture, relate issue #214 ; - go test and godoc has been updated	7 years ago
Ri Xu	9ee57fdb38	Fix typo and adding Chinese version document.	7 years ago
Ri Xu	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
Ri Xu	a6fc5a721d	- Make row index consistent in function `SetRowHeight` and `GetRowHeight`, fix issue #205 ; - go test and godoc has been updated	7 years ago
Ri Xu	dcbde4b831	- Add categories or values on reverse order (orientation of the chart) support, and set auto or fixed maximum, minimum of the axis, relate issue #202 ; - go test and godoc has been updated	7 years ago
Ri Xu	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
Ri Xu	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
Ri Xu	ecc3adf22a	- Add protection properties associated with the cell support, relate issue #191 ; - godoc and go test has been updated	7 years ago
Ri Xu	06e54bf1c6	Readme and godoc has been updated.	7 years ago
Ri Xu	45c31c4764	- Update the function `AddChart()`: clustered, stacked and 100% stacked bar and column series charts supported, relate issue #190 ; - go test and godoc has been updated	7 years ago
Ri Xu	b1b056e0eb	Handle special shared string table file name `xl/SharedStrings.xml`, relate issue #188	7 years ago
Ri Xu	9d7b94d760	Update godoc to make charts compatibility with WPS, relate issue #187 .	7 years ago
Ri Xu	7621927573	- Add a hyperlink to an image support for the function `AddPicture()`, relate issue #185 ; - go test and document has been updated.	7 years ago
dvelderp	b25ec6e9d3	xlsx.SetCellValue() now supports bool value	7 years ago
Ri Xu	50cdaed5a3	- Add 3D column and 3D 100% stacked column chart support, relate issue #160 ; - go test updated	7 years ago
Ri Xu	52b1a8e896	- Function `SetCellValue()` time.Duration support added, relate issue #176 ; - go test updated	7 years ago
xuri	443695732e	Merge pull request #153 from jinzhu/master Rename import path to github.com/360EntSecGroup-Skylar/excelize	7 years ago
Rohan Allison	cc1d3fefc2	Add stacked bar chart	7 years ago
Jinzhu	21214a514d	Rename import path to github.com/360EntSecGroup-Skylar/excelize	7 years ago
Ri Xu	f10ee929d0	- Bugfix: use sheet name in func `AddPicture`, relate issue #142 ; - godoc updated	7 years ago
Ri Xu	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
Ri Xu	e820388d70	Handle coordinate parse exception, relate issue #122 .	7 years ago
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	7 years ago
Ri Xu	3e7192b6ab	Simple go test.	7 years ago
Ri Xu	565b23e0e9	go test added for pull request #114	7 years ago
Ri Xu	1ec2661dda	Bugfix: deep copy issue with function `CopySheet()`, relate PR #108 .	8 years ago
Ri Xu	77af25295e	- Conditional format with formula support, relate issue #75 ; - go test and readme update	8 years ago
Ri Xu	67636039f6	- Init conditional format support, relate issue #75 ; - go test and godoc updated	8 years ago
Ri Xu	a8cf38ebd5	- New function `GetCellHyperLink()` added, relate issue #98 ; - go test added	8 years ago
Ri Xu	6626a26f7b	Simplify code and update unit tests.	8 years ago
Ri Xu	308776e350	Optimize code, go test and godoc updated.	8 years ago
Youngwan Kim	5a4870d1cf	Add extra argument "Linktype" to SetCellHyperLink it support "External" and "Location" Signed-off-by: Youngwan Kim <y103.kim@gmail.com>	8 years ago
Ri Xu	bbed2f6dc9	- Init create or remove panes support; - go test updated	8 years ago
Ri Xu	4a74951e81	- Support set custom number format, relate issue #86 ; - go test and godoc updated	8 years ago
Ri Xu	6aa59a1af2	- Init insert/remove column/row support. Relate issue #77 and #82 ; - Readme and go test updated	8 years ago
Ri Xu	101abe8e98	Add currency format code and go test updated.	8 years ago
Ri Xu	60fa5a5be1	- Display negative numbers by applying a red color supported; - go test updated	8 years ago
Ri Xu	bc31e545c8	- Currency format supported, relate issue #80 ; - go test and godoc updated	8 years ago
Ri Xu	20aae4e0e6	Repo URI changed.	8 years ago
Ri Xu	654a676d93	- New function `NewStyle()` added and function `SetCellStyle()` has been exported, relate issue #72 ; - go test and go doc updated	8 years ago
Ri Xu	86466654e2	- Unify the index row number index of functions `SetRowHeight()` and `GetRowHeight()` relate issue #68 ; - Unify the return value data type of functions `SetColWidth()` and `GetColWidth()`; - go test updated	8 years ago
Ri Xu	66e5d1fa80	API changed, use `NewFile()` instead of `CreateFile()` and use `SaveAs()` instead of `WriteTo()`.	8 years ago
Ri Xu	7bc43301da	- Support insert new lines into shape, relate issue #38 , note that the format set parameter of function `AddShape()` changed; - go test and go doc updated	8 years ago
Ri Xu	9928bbc7c8	- New functions `GetColVisible()` and `SetColVisible()` added, relate issue #61 ; - go test updated; - Fix typo	8 years ago
Ri Xu	a9f671d98f	- New functions: `GetSheetVisible()` and `GetRowVisible()` added, relate issue #61 ; - go test updated	8 years ago
Ri Xu	c89d842352	Init auto filter support, relate issue #59 .	8 years ago
Ri Xu	70f6328150	Support set font style of shape text. Relate issue #38 .	8 years ago
Ri Xu	cf97118bfe	- The max author and text in comment limit added; - go doc and go test updated	8 years ago
Ri Xu	d93a156355	Initialize comments support & go test updated.	8 years ago
Ri Xu	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
Ri Xu	7f30a6c943	- Initialize shape support: new function `AddShape()` added. Relate issue #38 ; - Drawing `nvPicPr` element ID property calculation changed; - go test updated	8 years ago
Ri Xu	46b8c46d91	- Initialize table support; - go test updated	8 years ago
Ri Xu	2868bd3ec9	- New function `HideSheet()` and `UnhideSheet()` added; - go test updated	8 years ago
Ri Xu	266d2c36e5	- Font bold, italic and underline style support. Relate issue #45 ; - Function `GetRows()` doc updated, relate issue #43; - go test and embed template updated	8 years ago
Ri Xu	d78ac4108c	- Update doc of function `AddChart()`; - Readme updated; - go test update	8 years ago
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	8 years ago
Ri Xu	6e287839ec	- Set number format for a cell support; - go test updated	8 years ago
Ri Xu	c7e277a07a	- New function `CopySheet()` added, relate issue #33 ; - Typo fixed; - go test updated	8 years ago
Ri Xu	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
Ri Xu	02b81b7efe	- Get an images in a cell supported, new function `GetPicture` added; - go test updated	8 years ago
Ri Xu	bee487c445	Leading space(s) character in cell value detection added. Related issue #32 .	8 years ago
Ri Xu	b6254209fe	- Set text in cell align support, note that the parameters of the `SetCellStyle` function have changed; - go test updated	8 years ago
Ri Xu	0d3452fbe2	- Delete sheet from workbook support, related issue #30 ; - go test updated	8 years ago
Ri Xu	68b4d1f546	- Set cell background color and style support; - Rename function `SetBorder` to `SetCellStyle`; - Complete `xlsxColor` structure definition; - go test updated	8 years ago
Ri Xu	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
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	8 years ago
Ri Xu	1e340aea40	Change function `AddPicture()` parameters to add add printing settings support. Related issue #27 .	8 years ago
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	8 years ago
Nikolas Silva	8ce12b60b8	Add SetRowHeight function	8 years ago
Ri Xu	a1060e779e	Make functions: `SetCellValue`, `SetCellInt`, `SetCellHyperLink`, `SetCellFormula`, `GetCellValue` and `GetCellFormula` to support the merged cells.	8 years ago
Ri Xu	c0a3020886	Support create merge cell.	8 years ago
Ri Xu	bd5b033b02	Support set work sheet background image.	8 years ago
Ri Xu	03234d6a25	Support add picture with offset and scaling.	8 years ago
Ri Xu	4a9b39afc6	- Add hyperlink and set formula support for cell support; - Character limits for cells added; - Update go test and fix typo	8 years ago
Ri Xu	52796f6e58	Format commants, break comments after 80 characters.	8 years ago
Ri Xu	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
Ri Xu	a99f0227b0	- New function `AddPicture()` added, support to add picture into excel cell; - go test updated; - fix typo and `gofmt -s` formatted	8 years ago
Sharsie	57fc2943ff	Add tests for the default cell value	8 years ago
Ri Xu	9e8d36ce59	- Performance improvement, remove `replaceRelationshipsID` and `workBookCompatibility` functions; - New functions `GetActiveSheetIndex`, `GetSheetName` and `GetSheetMap` added.	8 years ago
Ri Xu	30d0a2f40a	- New function `GetCellFormula` added; - Fix `GetCellValue` causes panic in some particular situation issues; - Go test updated	8 years ago
Ri Xu	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
Ri Xu	2a3620e750	BugFix: `SetCellValue` function assertion logic will cause panic in some case.	8 years ago
Ri Xu	78eb982052	Remove useless `.xlsx` tested files and go test updated.	8 years ago
Ri Xu	6185cd577d	Update go test.	8 years ago
Ri Xu	1a2570b873	Update go test case and update readme.	8 years ago
Ri Xu	e28de172c6	Update go test.	8 years ago
Ri Xu	cbfd657753	New function SetCellValue added and update godoc example.	8 years ago
Ri Xu	0dd0fba96b	Move execute checkRow logic when XLSX file open, speed up library write file.	8 years ago
Ri Xu	df8f85d6ab	Open file error return added and UpdateLinkedValue function added to fix linked values within a spreadsheet are not updating.	8 years ago
Ri Xu	50863294f9	Fix issue #2 change project to object-oriented style and update readme file.	8 years ago
Ri Xu	db47b6750d	Update readme and comments of the test file.	9 years ago
Ri Xu	0a0a36bafd	Update testing file more case added and reading cell value usage example in readme added.	9 years ago
Ri Xu	0e61ae7eda	1) Update readme file credits and go report badge added; 2) Remove use less function; 3) Update test file.	9 years ago
Ri Xu	3c4ad28db7	- Get cell value support - Optimisation code use fmt package - Update README - Remove useless function	9 years ago
Ri Xu	0d60020f96	Update test file.	9 years ago
Ri Xu	a9d3ee2869	Init commit.	9 years ago

1 2 3 4 5

222 Commits (master)