Issue in workbookOptions() method

[Procurement]

Hi Team,

We are using the kendoreact library in our react code. There is an issue while using workbookOptions(). 
It fails to recognize date format in dd.mm.yyyy format. Its working fine with dd/mm/yyyy and dd-mm-yyyy format. 
So we end up with excel sheets without data.
Are you ( kendo team) aware of this issue. If so, what is the fix for this?

Regards,

Pratap

[Konstantin Dikov]

Hi Pratap,

I have tested the following simple example by adding a Date value to one of the cells with "dd.mm.yyyy" format, but it exports correctly:

• https://stackblitz.com/edit/react-fxabni-tqle6t?file=app%2Fmain.tsx

Could you please share an example demonstrating the issue, so we can test and debug it locally?

Looking forward to your reply.

 

Regards,
Konstantin Dikov
Progress Telerik

[Procurement]

Hi Konstantin,

                      Given the Input Sheet which is 'sheets' in the first line which is attached and the following piece of code.

const workbooks = sheets.map(sheet => this[sheet.ref].workbookOptions());

    workbooks.forEach(book => {

      const rows = book.sheets[0].rows;

      rows.forEach(row => {

        if (row.type === "group-header") {

          row.cells.forEach(cell => {

            var element = document.createElement("textarea");

            element.innerHTML = cell.value;

            cell.value = element.value;

          });

        }

      });

    });

    workbooks[0].sheets = workbooks.reduce((acc, x, i) => {

      x.sheets[0].name = sheets[i].title;

      return [...acc, ...x.sheets];

    }, []);

    this[sheets[0].ref].save(workbooks[0]);

    console.log("workbook", workbooks);

  };

 

We get all data as empty. Not sure what is the issue here. Can u help us with this?

 

[Konstantin Dikov]

Hi,

The problem that you are facing is due to the fact that the date format with the dots is actually used as field name and the dot is special character in regards of column fields for accessing nested properties (Category.CategoryName for example). What I could suggest is to replace the dots with different symbol while the workbook is created and then replace them back to dots in the generated header cells. 

Please let me know if the issue persists after applying the suggested changes.