Export excel columns types

Tags: #<Tag:0x00007efc655cd650>
#1

I am exporting my handsontable to Excel

Below is my Column

{
    data: 'UseYear',
    type: 'numeric',
    numericFormat: {
      pattern: '0.00'
    }
 },

Whenever i export it to excel its data type shown on Excel is General, it needs to be Number. I want its type to be Number in Excel.

#2

Hey @bashialee

Handsontable exports data to the .csv format. This format has its limitations.

is plain text using a character set such as ASCII, various Unicode character sets (e.g. UTF-8), EBCDIC, or Shift JIS,

You are able to pass anything that you get by calling instance.getData() but styling, formatting and all the cell meta are gone.

#3