HTML Report from Blue prism

[shiva2791]

Dear friends,

I want to create one HTML report from the MS Excel document through Blue prism RPA automation, I have one hands on VB Script to do this, but in code stage its not working. If anyone done this kind of use-case, please help me with your valuable suggestions.
Thanks

 

[Sachin_Kharmale]

Hi Shiva,

Explain your requirement in detail so we can look into it.

 

[shiva2791]

Hi Shiva,

Explain your requirement in detail so we can look into it.

Hi Sachin,

I am having one Excel file or SQL Table with 10 columns and 20 rows (Consider). I wish to show it in html report format to my super managers so that they can view the progress alone not all the data., say MIS reports. I have one VB code also to do this, (code written in Visual Basic, to get the html report using Data tables). I wants to use the same code or any other idea to get HTML report with some visualizations like Pie or Bar chart for my table data either in MS Excel format or MS SQL Server table format.

Hope I have explained little broader now, Please suggest me some ideas...

Thanks..

 

[Sachin_Kharmale]

Hi Shiva,
We can do generate pie chart in excel with the VB Code in code stage.
the code which you have try these code with code stage. so the pie chart will be generate in excel file.
if you required further assistance i will help you just provide some sample data and expected demo output.