Read From CSV and write to Excel

vishnublueprism@gmail.com posted this 03 May 2019 - Last edited 03 May 2019

Hello IntelliBot Team,

can someone please help me to understand, how we can read from the CSV file and write to Excel.

The components I have used are..

1. Read From CSV (Successfully read data from CSV file delimited by "," )

2. Write to Excel (Where the data stored in Excel in a single column)

Note: While using the ReadFromCSV with delimiter its throwing the following error

Component 'ReadFromCSV' failed to execute.

Exception has been thrown by the target of an invocation.

Input array is longer than the number of columns in this table.

Can someone please help me to solve to get the data from CSV to EXCEL without delimiter.

Regards

Vishnu

2 Comments

Order By: Standard | Newest | Votes

Swathi Muppalla posted this 06 May 2019

Hi Vishnu,

Our Technical team is looking into it, we will get back to you soon.

Thanks & Regards

Swathi Muppalla

Swathi Muppalla posted this 15 May 2019 - Last edited 15 May 2019

Hi Vishnu,

The issue pertaining to "ReadFromCSV" component has been resolved. Kindly follow the steps mentioned below.

To Read Data From a CSV, TSV or PIPE separated files formats:

1. In the Toolbox, expand Utilities and then expand Data Reader.

2. Drag the ReadFromCSV component and drop it on the Design surface.

3. To specify the file location, double-click FilePath and enter the location of the file.

4. To override the existing data source, right-click FilePath.

5. If you want Header Select True, else Select False (Boolean) type.

Note:

· ReadFromCSV also supports (TSV files, PIPE separated) files.

· Based on the requirement the Delimiters can be changed.

For example: In ‘CSV’ File the Delimiter can be the following “,” |

In ‘TSV’ File the Delimiter can be “\t “

Thank you for contacting Intellibot Support team.

Please feel free to reach out to us for any further clarifications.

Regards,

Swathi Muppalla