Excelize

Fork

Merge pull request #18 from nikolassilva/master

Add SetRowHeight function

Add SetRowHeight function

Make functions: `SetCellValue`, `SetCellInt`, `SetCellHyperLink`, `SetCellFormula`, `GetCellValue` and `GetCellFormula` to support the merged cells.

Support create merge cell.

Support set work sheet background image.

Fix issue #17, update README and fix typo.

Update README, godoc and fix typo.

Support add picture with offset and scaling.

- Add hyperlink and set formula support for cell support;
- Character limits for cells added;
- Update go test and fix typo

Format commants, break comments after 80 characters.

- 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

- New function `AddPicture()` added, support to add picture into excel cell;
- go test updated;
- fix typo and `gofmt -s` formatted

Merge pull request #15 from Sharsie/feature/DefaultCellVal

Setter function to set raw values into a cell

Add tests for the default cell value

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

Fix issue struct field `paperHeight` has xml tag but is not exported.

- Performance improvement, remove `replaceRelationshipsID` and `workBookCompatibility` functions;
- New functions `GetActiveSheetIndex`, `GetSheetName` and `GetSheetMap` added.

- Fix issue: sheet protection and conditional formatting proprietary missing after save;
- Update workbook and sheet relationships and self-close tag replacement hack functions

- 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)

- New function `GetCellFormula` added;
- Fix `GetCellValue` causes panic in some particular situation issues;
- Go test updated

Change complete rows logic to fix call `SetCellValue`makes file corruption in some case.

- 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

- 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)

- Fix issue background image and table missing after save;
- Update test template for this fix

Fix hyperlink missing after save issue and update completion row element logic to enhance compatibility.

BugFix: `SetCellValue` function assertion logic will cause panic in some case.

Update README.

Remove useless `.xlsx` tested files and go test updated.

Merge pull request #11 from NaySoftware/master

looping on rows columns functionality

sheet re-arrange