ParamQuery grid support forum

General Category => Help for ParamQuery Pro => Topic started by: luckduck on May 28, 2020, 10:51:55 am

Title: Import text only when importing Excel
Post by: luckduck on May 28, 2020, 10:51:55 am

Hi Paramvir,

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

Title: Re: Import text only when importing Excel
Post by: paramvir 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

Title: Re: Import text only when importing Excel
Post by: luckduck on May 28, 2020, 03:11:27 pm

I solved it with your help. Thank you.