- Posts: 4
All Excel Fields Formatted as General
- B.Greenway
- Topic Author
- Offline
- User
Less
More
10 years 6 months ago #2321
by B.Greenway
All Excel Fields Formatted as General was created by B.Greenway
Hello, I'm trying to do some basic .csv. to .xlsx file conversions where the output fields have to be formatted as either number or text.
In this case number actually being in the format of 123.00, 456.00 etc where the input is just 123 or 456, and text just a plain text field.
Whenever I try this conversion everything is formatted in the output as general, I've tried everything from setting the format on the output, to including the format heater and setting it to decimal, double and integer, they all just come out as general.
Any ideas on what to try next?
Thanks in advance.
In this case number actually being in the format of 123.00, 456.00 etc where the input is just 123 or 456, and text just a plain text field.
Whenever I try this conversion everything is formatted in the output as general, I've tried everything from setting the format on the output, to including the format heater and setting it to decimal, double and integer, they all just come out as general.
Any ideas on what to try next?
Thanks in advance.
Please Log in or Create an account to join the conversation.
- FlowHeater-Team
- Offline
- Admin
10 years 6 months ago #2322
by FlowHeater-Team
Best wishes
Robert Stark
Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.
Replied by FlowHeater-Team on topic All Excel Fields Formatted as General
Hi,
FlowHeater doesn’t set the Excel Format of a column, always the standard excel cell format should be taken. In case you create a new Excel workbook the following standard Excel cell format will be used, but this format depends a bit on your used Excel settings
FlowHeater Data Types
If you want to add data to an existing Excel Sheet FlowHeater use the format of this Excel Sheet, no format will be changed.
In the attachment you’ll find a little example. In case your problem isn’t solved please post your used FlowHeater Definition File for further investigation.
FlowHeater doesn’t set the Excel Format of a column, always the standard excel cell format should be taken. In case you create a new Excel workbook the following standard Excel cell format will be used, but this format depends a bit on your used Excel settings
FlowHeater Data Types
- FlowHeater data type Integer: Whole numbers without decimals
- FlowHeater data type Decimal: Numbers with usually two decimals
- FlowHeater data type DateTime: Date and Time, the output format depends on your PC settings
- FlowHeater data type String: No further format
If you want to add data to an existing Excel Sheet FlowHeater use the format of this Excel Sheet, no format will be changed.
In the attachment you’ll find a little example. In case your problem isn’t solved please post your used FlowHeater Definition File for further investigation.
Best wishes
Robert Stark
Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.
Attachments:
Please Log in or Create an account to join the conversation.
Time to create page: 0.258 seconds