[Office Template] Insert non text data into existing excell column

[Office Template] Insert non text data into existing excell column

  
Forge Component
(23)
Published on 2014-01-03 by Paulo Garrudo
23 votes
Published on 2014-01-03 by Paulo Garrudo

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

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-

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.