Copy sheet from workbook which contains custom cell style to another workbook

Copy sheet from workbook which contains custom cell style to another workbook

Posted by: vumanhhungtcgl on 2 January 2023, 10:33 pm EST

• 

  vumanhhungtcgl

  • Post Options:
  • Link
    Copy

  Posted 2 January 2023, 10:33 pm EST

  Hi,
  
  I currently face an issue when i copy a sheet from workbook 1 that contains some custom cell style, which has been set from Excel to another workbook named wb2 .
  
  I try using copyTo method or fromJson but 2 method not copy custom cell style. When i export workbook wb2 it got “undefined e.backcolor”.
  
  Please provide me a way to fix this issue.

• 

  avinash.pathak

  • Post Options:
  • Link
    Copy

  Posted 3 January 2023, 1:11 am EST - Updated 3 January 2023, 3:29 am EST

  Hi,

  We are sorry we are unable to replicate the issue at our end. Could you please share a working sample that replicates the issue so that we could investigate it further and help you accordingly.

  Regards,
  
  Avinash

• 

  vumanhhungtcgl

  • Post Options:
  • Link
    Copy

  Posted 4 January 2023, 12:15 am EST - Updated 4 January 2023, 12:20 am EST

  I’m currently using Linux and not having Excel now.
  
  I worked follow below step:
  
  Firstly, I used Excel and added some custom styles then i imported that file by ExcelIO. After that i tried to copy one sheet from that workbook to another workbook which wasn’t having that custom styles. After copy spreadjs like was not copy custom styles like Excel then i got that error.
  
  I’ll post specific demo later.

  

  868×665 89.1 KB

• 

  avinash.pathak

  • Post Options:
  • Link
    Copy

  Posted 4 January 2023, 2:37 am EST

  Hi,

  I have also perform the same steps and unable replicate the issue. I have used the following excel file. Please share the a sample that replicates the issue for deeper investigation.

  Regards,
  
  Avinash

  customCellStyle.zip