sheetjs issues

Rearranging the XLSX.write order

1

Hi is it possible to write the output to the excel file as shown below? Have the headers in one column (A1) and data in another (B1). ![image](https://user-images.githubusercontent.com/19972882/193199794-a815e181-5526-4cb7-a991-5b817a595801.png) Rather than...

HarshaKosala

Make all empty cells default format?

2

So currently my empty cells are formatted to be general. Is there a way for me to format all empty cells to be text? currently using aoa_to_sheet()

btrangcasestack

Fix for Issue 2752 where blankrows:true skips first blank line

1

This PR tries to solve #2752 which is also mentioned in PR #2776 but it did not pass all tests of a PR as set by SheetJS. This PR consists...

abhiram11

Worksheet Dimensions: fix examples by automatically deducing range

2

There's this `!ref` property that corresponds to [Worksheet Dimensions](https://c-rex.net/projects/samples/ooxml/e1/Part4/OOXML_P4_DOCX_dimension_topic_ID0EZ2X4.html). Documentation states: > It specifies the row and column bounds of **used** cells in the worksheet > When an entire column...

Vanuan

fix: getTimeZoneOffset needs to return a double instead of integer at v8

3

I found that the return time of the datenum method in Chrome browser is incorrect, consider customizing a getTimeZoneOffset function to fix Date.prototype.getTimezoneOffset() return error value

queguangwei

fix-2824_numbers rounding

2

some kind of solution for this issue https://git.sheetjs.com/sheetjs/sheetjs/issues/2824

andrei-kav

format entire column

4

This is more of a question. I have scoured the internet trying to find out if there is a way to format an entire column as text. My "source" sheet...

slymuffhugger

Still a problem with date parsing

6

I've read issues similar to mine, but I haven't found a solution yet. I made a CSV-file in a texteditor, VI, so no Excel-involvement here. I entered a date in...

svendeckers