Comments (2)
The changes you proposed in the pull request #7 are made to the source files under bits
and compiled. There is a new test in tests\test-styles.js
that verifies styles in blank cells persist round trip. Changes are merged into the beta branch (https://github.com/protobi/js-xlsx#beta), tagged as version 0.8.6 and published to npm and bower.
describe('styles with blank cells', function () {
it ('retains styles with blank cells', function() {
var OUTFILE = '/tmp/ex1.xlsx';
var OUTFILE2 = '/tmp/ex1a.xlsx';
var workbook = {
SheetNames : ["Sheet1"],
Sheets: {
"Sheet1": {
"B2": {v: "Top left", s: { border: { top: { style: 'medium', color: { rgb: "FFFFAA00"}}, left: { style: 'medium', color: { rgb: "FFFFAA00"}} }}},
"C2": {v: "Top right", s: { border: { top: { style: 'medium', color: { rgb: "FFFFAA00"}}, right: { style: 'medium', color: { rgb: "FFFFAA00"}} }}},
"B3": {v: "Bottom left", s: { border: { bottom: { style: 'medium', color: { rgb: "FFFFAA00"}}, left: { style: 'medium', color: { rgb: "FFFFAA00"}} }}},
"C3": {v: "", s: { border: { bottom: { style: 'medium', color: { rgb: "FFFFAA00"}}, right: { style: 'medium', color: { rgb: "FFFFAA00"}} }}},
"!ref":"B2:C3"
}
}
};
// write the file and read it back...
XLSX.writeFile(workbook, OUTFILE, {bookType: 'xlsx', bookSST: false});
var workbook2 = XLSX.readFile(OUTFILE, {cellStyles: true});
assert(basicallyEquals(workbook.Sheets, workbook2.Sheets));
XLSX.writeFile(workbook2, OUTFILE2, {bookType: 'xlsx', bookSST: false});
var workbook3 = XLSX.readFile(OUTFILE2, {cellStyles: true});
assert(basicallyEquals(workbook.Sheets, workbook3.Sheets))
});
});
from js-xlsx.
Nice, perfect
from js-xlsx.
Related Issues (20)
- Add comments/note can not export or export very slow, without comments, it will export very quick
- vite上怎么配置config.externals({ "./cptable": "var cptable" }); HOT 8
- add some comment XLSX.write page unresponsive
- Why I installed js-xlsx, there is no json_to_sheet method after import
- Not able to at add comments to the cell while writing it through xlsx-style.
- Depends on vulnerable versions of jszip
- cptable is not defined
- Need to remove unprotected cells containing formula warning icon in excel sheet
- How to set cell wrapping?
- How to parse ‘excel formula' using node js to get the actual value from the excel sheet.
- How use typescript in this project?
- Please lock the commander version, otherwise it cannot support Node v12
- Read styles for HTML table cell
- jszip is not a constructor
- How to set different text styles in cells with xlsx-style , example: C3:{ t : "s" v : "<p>Update Wifi long-term supply <span style=\"text-decoration: underline;\">plan</span> and impact to <strong>production</strong> }
- js.forEach is not a function HOT 1
- RollupError: Could not resolve "../xlsx" from "../xlsx?commonjs-external" HOT 1
- Denial of Service (DoS) affecting package jszip.
- Excel to PDF Page size and scaling issue
- what is this issue i am not able to understand and resolve
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from js-xlsx.