Support > Forums > OpenBots Studio > Can't write datatable to excel

Can't write datatable to excel

David Vega

  • Reporter
  • Calender Icon December 21,2022 at 4:43 PM

Hello,

i am starting using open bots and i am trying to write a datatable to excel but i am getting the following error:

Input string was not in a correct format.Couldn't store <> in Mycolumn Column. Expected type is Double.

The datatable is filled with database query.

Thanks for your help

This forum has 314 topics, 681 replies, and was last updated 21 days ago by Support Agent

Nataly Alvarado...

  • Participant
  • Calender Icon December 21,2022 at 11:14 PM

Hi David Vega,

Please note that as of Studio v1.8.6, the datatable content must be in string format.

For now, as a workaround we recommend to convert the table columns to string type, before writing the table to Excel. This can be done by using a C# code snippet via the Evaluate Snippet command.

Also note that support for different variable data table column types will be added for Studio release v2.0.

Please let me know if you need additional information.

You are not authorized to reply, please click here to login and add your reply to this topic.