VB.Net code to convert .csv file to .xlsx file

Help Studio
, ,
1

Hi,

Can anyone suggest me with VB.net code that I can use to convert .csv file to .xlsx file.
I cannot use UiPath activities, As I have few infra issues which is making excel to open multiple times not viable option

2

Hi!

You can read the csv-file using
Activities - Read CSV

And then write to an xlsx using this
Activities - Write Range Workbook

The workbook activities in the Excel package don’t require Excel to be installed:

image
image875×150 18.4 KB

3

Hi @sven.wullum1 ,

I cannot do this as sheet name is different for each transaction. I don’t have access to modern folders as of now

4

Maybe I misunderstood.

Do you want to convert an xlsx into a csv?

5

No, From csv to xlsx

6

CSV don’t have sheets, so you can call the sheet in the xlsx whatever you want.

7

We are downloading csv file from another application which contain sheets

8

Do you have an example?

I really was under the impression that CSV’s don’t have sheets the way a workbook has.

1 Like
9

@hemasai.06

CSV can never have sheets…thats not the csv structure

@sven.wullum1 - you are correct they wont have sheets

cheers

2 Likes