Hello, i have an error when using two columns

TypeError: e.columns[r] is undefined

I just modify the HTML on demo

<table id="simpleTable1" data-cols-width="70,15,10">
        <tbody>
          <tr>
            <th data-a-text-rotation="-45">Col 4 (date)</th>
            <th data-a-text-rotation="-90">Col 5</th>
          </tr>
          <tr>
            <td data-t="d">05-20-2018</td>
            <td data-t="n" data-num-fmt="$ 0.00">2210.00</td>
          </tr>
        </tbody>
      </table>

      <button id="button-excel">Create Excel</button>

Hi,

In Norway we format our dates as DD-MM-YYYY. Would it be possible to add support for this in the data-t="d" attribute?

Do you know, how to import library for webpack ?
I want to use it in SPA (vue js)
But module-bundler told me that relative modules not founded

I am try to add currency in excel sheet but there is no option I could found for that. Can you add that option like other data-t="c" - for currency.

If I attempt to convert a table with multiple rows that contain colspan cells, I get an error:

Cannot merge already merged cells

Here's an example on CodePen (you can see the error in the browser console):
https://codepen.io/anon/pen/dwKOmr

This previously worked (prior to v1.0.0).

One File, Multiple Sheets Per Table

After giving data type as date, the value exported to excel is the value of 1 day before.

I cannot set height for row
Can You help me?

Hi, I'm using TableToExcel to download a table that can be sometimes pretty big, and it takes up to 10-15 seconds for the download to start. I've been tasked with showing some visual cue that the download is preparing. I'm using jQuery.
I've tried to change the style/color of the download icon right before calling TableToExcel, but it seems this change doesn't have time to be reflected on the page before TableToExcel starts processing, because the color changes once the download has finished.
Any idea how I can achieve that?
The only thing working is to display an alert, but ... that's not a great solution.

Thanks
Damien

I'm getting warnings when I try to use this library with vue2 and webpack.

warning in ./node_modules/@linways/table-to-excel/dist/tableToExcel.js
1:261-262 Critical dependency: require function is used in a way in which dependencies cannot be statically extracted

warning in ./node_modules/@linways/table-to-excel/dist/tableToExcel.js
1:290-294 Critical dependency: the request of a dependency is an expression

Hello,
the lib is perfect but it's not working on IE11, because of Object.assign.
I was trying to add the polyfill but still not working trowing the following error:

'Symbol' is undefined

Can somebody help?

In English locales it is common to separate thousands by using a comma ie 1000 -> 1,000, also for readability zeros are replaced with a '-' (see jquery datatables)

If you were to feed either of these numbers into the parser a NaN error would result with warning for end user.

Consider either a global or cell specific (when data type is numeric) processor.

A quick and dirty deals with the global (not ideal as there may be legitimate string uses for ','

function makeXLSXExport(tableId) {
  let table = document.querySelector("#"+tableId);
  let tableT = table.cloneNode(true);;
  tableT.innerHTML = tableT.innerHTML.replace(/,/g,''); //replaces , globally
  tableT.innerHTML = tableT.innerHTML.replace(/>-</g,'><'); //replaces cells only containing - globally
  TableToExcel.convert(tableT);
}

My html table has currency value with dollar symbol($) and comma(,) as separator.
After exporting this to Excel, while opening excel is showing warning and also respective column has NaaN instead of data.

Consider allowing inheritance of attributes from parents (ie table->row->cell or table->col->cell).

So instead of:

<table>
   <tr>
      <th data-a-wrap="true" data-f-bold="true"> Header</th>
      <th data-a-wrap="true" data-f-bold="true"> Header 2 </th>
      <th data-a-wrap="true" data-f-bold="true"> Header 3</th>
   </tr>
</table>

Support:

<table>
   <tr data-a-wrap="true" data-f-bold="true">
      <th> Header</th>
      <th> Header 2</th>
      <th> Header 3</th>
   </tr>
</table>

Compiled with warnings.

./node_modules/@linways/table-to-excel/dist/tableToExcel.js
Critical dependency: the request of a dependency is an expression

I get the above warning when including as import TableToExcel from "@linways/table-to-excel", I'm using this in react with create-react-app.

I have also tried const TableToExcel = require("@linways/table-to-excel"); and import TableToExcel from "@linways/table-to-excel/dist/tableToExcel"; but get the same error.

th data-b-a-s="thin" data-a-h="center" data-f-bold="true" colspan="2"

Above line of code does not work perfectly and weird border style get displayed in excel.

Hi!
Anyone can help me?
I have a HTML with my table and I'm using style classes in td and/or tr. I need to add a hyperlink on cell, but I don't find how to do that.
Also, I will like to add more than one hyperlink at the same cell (td).
Anyone have any example to help me?

Is it possible to use percentage values where you are including the % symbol in the html?

If i use a % symbol and then try to set the cell as data-t="n" is caused the cell to display "NaN"
If I do not add data-t="n" excel treats the cell as a text field.

Here is a code pen showing the problem I am currently experiencing

https://codepen.io/coxy121/pen/KKPNPoa

Can this library export tables with pagination?

In cell, Can you use different text formats, font-size and type? because I have many different format text in cell

Originally posted by @NguyenTheSon in #11 (comment)

Hi!

I'm implemted succesfully an app with table to excel export, with this approach:

TableToExcel.convert(document.getElementById("table_SP_HOME_VER_PARTE_LOGIS_227"));

in the attach file, that line works fine with table2.html, but when I want to implement a new table (table1.html) it fails with this error:

TableToExcel.convert(document.getElementById("table_SP_GRD_RENDICION_228"))
tableToExcel.js:2 Uncaught TypeError: Cannot set property 'width' of undefined
    at tableToExcel.js:2
    at Array.forEach (<anonymous>)
    at Object.parseDomToTable (tableToExcel.js:2)
    at Object.tableToSheet (tableToExcel.js:508)
    at Object.tableToBook (tableToExcel.js:508)
    at Object.convert (tableToExcel.js:508)
    at <anonymous>:1:14

I don't understand why...

thnks in advance!

examples.zip

Hi, how can I include multiple tables in one file separated by sheets?

I already tried using two TableToExcel functions with different IDs and sheet names with the same file name, but it ended up downloading two separate files instead.

Here's what I did:

let button = document.querySelector("#button-excel");

button.addEventListener("click", e => {
  TableToExcel.convert(document.querySelector("#table1"), {
  	name: "FileName.xlsx",
  	sheet: {
  		name: "Sheet 1"
  	}
  });
  TableToExcel.convert(document.querySelector("#table2"), {
  	name: "FileName.xlsx",
  	sheet: {
  		name: "Sheet 2"
  	}
  });
});

Are there any functions that can be used to make this possible?

Hi,
if the no of cells is less than the no of col widths specified an error is thrown.In my case i cannot predict no of cells in an excel.Is it possible to not throw an error?