ParamQuery Grid
Welcome,
Guest
. Please
login
or
register
.
1 Hour
1 Day
1 Week
1 Month
Forever
Login with username, password and session length
Home
Help
Search
Login
Register
ParamQuery grid support forum
»
General Category
»
Help for ParamQuery Pro
»
Import text only when importing Excel
« previous
next »
Print
Pages: [
1
]
Author
Topic: Import text only when importing Excel (Read 1778 times)
luckduck
Pro Ultimate
Newbie
Posts: 46
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?
Logged
paramvir
Administrator
Hero Member
Posts: 6310
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
Logged
luckduck
Pro Ultimate
Newbie
Posts: 46
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.
Logged
Print
Pages: [
1
]
« previous
next »
ParamQuery grid support forum
»
General Category
»
Help for ParamQuery Pro
»
Import text only when importing Excel