Store cells as excel number and not as excel text

[mattwilsn]

var sheet = workbook.createSheet('mySheet', 3, 3);

var myInt = 42;

sheet.set(2,4,myInt);

on save/create of mySheet excel myInt is created as a text input.

I have to manually convert every cell to an excel number.

Is there a way to create a workbook with numbers and not text?

[pietersv]

In the meantime, an option is to copy https://raw.githubusercontent.com/protobi/msexcel-builder/master/lib/msexcel-builder.js to your project. Let me know if this fix works
update See pull request #46

[premchander]

We have tested it. It is not working.

[pietersv]

Sorry, I should have updated this discussion thread. Shortly afterward had submitted this pull request (#46) to write numbers as numbers.

You can use this branch, https://github.com/protobi/msexcel-builder. For a test, run mocha test/example.js which writes an output file to /tmp/example2.xlsx. This mocha test does't (yet) actually read the generated programatically to verify that. But if you open the file, you should see numbers as numbers, text as text.

[mattwilsn]

msexcel-builder-colorfix-intfix

Here is an npm package that includes this fix as well as another known cell color issue. I am currently using this and it is working.

[premchander]

Thanks Pietersv and Mattwilsn for resolving my issue. Now its working fine.

@mattwilsn
But font color in msexcel-builder-colorfix-intfix is applying for the fonts in excel cell. Only background color is applying for cell.

How to apply font color for fonts in cell?

Thanks