I had excel in storage bucket , i want to read that excel . but in studio the read storage data is in string format . how can i convert to datatable

Help StudioX
,
3

Hi @Mithesh_Reddy_Bolla,

There 2 things here that you can do:

  1. Either use download file activity for storage bucket to download that excel file, once downloaded, read it using read range activity under excel application scope like normal excel file as suggested by @sangeethaneelavannan1 also. This would store the result in data table.

  2. You can consider using Json format instead of excel file, read or using using read storage text, deserialize json, and then build table from that json.
    For this, refer below link on how to convert json object to datatable.

You can try either of these approaches but main question is which option is worth the efforts?

If I may ask, why are you considering storing file on storage bucket, which file is this(config file or input file) and is it a mandate to have it in excel format itself?

Regards
Sonali