Dynamic data import / export

datenbank

simply more productive
Up to 100,000 records can be processed with the freeware version!
Welcome, Guest
Username: Password: Remember me
Welcome to the FlowHeater support forum.

Questions about using FlowHeater are answered here.
  • Page:
  • 1

TOPIC: Format Excel number without decimals

Format Excel number without decimals 4 years 1 month ago #2261

  • FlowHeater-Team
  • FlowHeater-Team's Avatar Topic Author
  • Offline
  • Administrator
  • Administrator
  • Posts: 254
Hello,

could you please tell me why when I open an excel document in flowheater in the ID section it shows a number with two decimals after each item number. In the excel spreadsheet I changed item ID to GENERAL category instead of number, but it didn't help.

Thank you,
Elena

Support request received via email

Please Log in or Create an account to join the conversation.

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.

Re:Format Excel number without decimals 4 years 1 month ago #2262

  • FlowHeater-Team
  • FlowHeater-Team's Avatar Topic Author
  • Offline
  • Administrator
  • Administrator
  • Posts: 254
Hi Elena,

FlowHeater detect numbers in Excel sheets always as FlowHeater data type decimal or double. In case you would like to export these values without decimals you just have to switch the FlowHeater data type manually to the FlowHeater data type INTEGER. That’s all.

Attachments:

Please Log in or Create an account to join the conversation.

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.
  • Page:
  • 1
Moderators: FlowHeater-Team
Time to create page: 0.081 seconds