Author Topic: Import text only when importing Excel  (Read 1779 times)

luckduck

  • Pro Ultimate
  • Newbie
  • *
  • Posts: 46
    • View Profile
Import text only when importing Excel
« on: May 28, 2020, 10:51:55 am »
Hi Paramvir,

When importing Excel, can you import only cell values ​​excluding cell styles?


paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6310
    • View Profile
Re: Import text only when importing Excel
« Reply #1 on: May 28, 2020, 11:37:17 am »
There is no declarative option for it.

However it can be done programatically by importing Excel into a js workbook, then iterate through all columns, rows & cells and clear all style values before importing js workbook further into grid.

https://paramquery.com/pro/api/excel-workbook

luckduck

  • Pro Ultimate
  • Newbie
  • *
  • Posts: 46
    • View Profile
Re: Import text only when importing Excel
« Reply #2 on: May 28, 2020, 03:11:27 pm »
I solved it with your help. Thank you.