Jump to content

Dynamic recognition of cell type excel


Recommended Posts


I have a report that may look like this simplified:

String, String, Integer, Integer, String

Or sometimes, i could change dynamicaly and look like this:

String, String, String, Integer, Integer

Or any other combination.

Is there any way i can get Excel reports to format numbers as numbers and strings as strings?

I can't set the correct datatypes of my textfields in templates, because it is determined on runtime. The only way I see i using the API to replace textfields with designTextfields, which can have their class type set.

Am I missing something, or is this the only way? Any help is very appreciated:)




Link to comment
Share on other sites

  • Replies 10
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Actually.. If you don't know what datatype the fields will be, how do you have them set in the report? I'm pretty sure it just going to determine the cell type based on the datatype of the field, which will remain static after the report is created. How are you dynamically changing the datatypes of the fields in the report?
Link to comment
Share on other sites

That is excatly what I'm wondering how to do. I think "detect cell types" only will read the type of the textfield in the report template, and convert the value to it. What I need is the other way: to read the type of the value, and convert the textfield to it..
Link to comment
Share on other sites

  • 2 weeks later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...