Skip to Content (Press Enter)
UserImage.jpg
Pedro Tavares
25Views
2Comments
[Office Template] Insert non text data into existing excell column
Question
Forge
officetemplate-png
Web icon
Office Template (O11)
Forge asset by Arquiconsult

Hi

I'm trying to use a template excel file (stored in the resources) and insert data into the template. So far I can manipulate all the data, insert any value (decimal, text, date) into any column.

My problem is that when I download the excell file, all the data that I inserted is Text type and I need it to be decimal or whatever.

My excell file has formulas that only work if the data is decimal (in this case)

Thanks in advance,


Pedro Tavares

0
0
18 Aug 2017
Copy Link
2023-09-06 11-31-56
Hitesh Maran

Hi Pedro,

Your requirement like once you download Excel file then you are able to perform excel formulas like Average, Sum, Count. So i suggest use forge components "Excel_Package". 


Thanks,

-HM-

0
0
18 Aug 2017
Copy Link
UserImage.jpg
Pedro Tavares

hitesh maran wrote:

Hi Pedro,

Your requirement like once you download Excel file then you are able to perform excel formulas like Average, Sum, Count. So i suggest use forge components "Excel_Package". 


Thanks,

-HM-

Hi Hitesh,


Unfortunately that component doesn't help me either, when I try to add a value I need to specify the value type and it always returns an error.


Thanks anyway.

0
0
21 Aug 2017
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.