Excel Datasource automatic refresh data

Stimulsoft Reports.NET discussion
Post Reply
acataluffi
Posts: 21
Joined: Tue Apr 26, 2022 2:06 pm

Excel Datasource automatic refresh data

Post by acataluffi »

Hi,
i'm trying to do a dashboard with Excel or CSV as datasource.
Right now, i just used Excel and I can see two different situation:
1. if i modify data (in Excel) in my .NET Viewer data doesn't update, so i should re-upload the dashboard datasource from .NET Designer Online.
2. if i modify data in my Stimulsoft designer DESKTOP APPLICATION data is automatically uploaded to the last file update.

My question is: how can i automatically upload data in my .NET Viewer too to see the update without reload datasource? Is it possible or not?

Thanks, I hope I was understandable
Lech Kulikowski
Posts: 6197
Joined: Tue Mar 20, 2018 5:34 am

Re: Excel Datasource automatic refresh data

Post by Lech Kulikowski »

Hello,

> 1. if i modify data (in Excel) in my .NET Viewer data doesn't update, so i should re-upload the dashboard datasource from .NET Designer Online.

How excel data was added to that report?

Thank you.
acataluffi
Posts: 21
Joined: Tue Apr 26, 2022 2:06 pm

Re: Excel Datasource automatic refresh data

Post by acataluffi »

Lech Kulikowski wrote: Mon May 09, 2022 9:20 pm Hello,

> 1. if i modify data (in Excel) in my .NET Viewer data doesn't update, so i should re-upload the dashboard datasource from .NET Designer Online.

How excel data was added to that report?

Thank you.

Hi,
i should load the file from .NET Designer and not by code.
So, from .NET Dashboard > Dictionary > Data Source > Add Data source
Lech Kulikowski
Posts: 6197
Joined: Tue Mar 20, 2018 5:34 am

Re: Excel Datasource automatic refresh data

Post by Lech Kulikowski »

Hello,

In the data source to the excel file is a specified path or added as a resource?

Thank you.
acataluffi
Posts: 21
Joined: Tue Apr 26, 2022 2:06 pm

Re: Excel Datasource automatic refresh data

Post by acataluffi »

Lech Kulikowski wrote: Wed May 11, 2022 9:41 am Hello,

In the data source to the excel file is a specified path or added as a resource?

Thank you.
Hi,

i get it as a file from file input

Thank u
Lech Kulikowski
Posts: 6197
Joined: Tue Mar 20, 2018 5:34 am

Re: Excel Datasource automatic refresh data

Post by Lech Kulikowski »

Hello,

You can set the RefershTime option for the dashboard to automatically update data.

Thank you.
acataluffi
Posts: 21
Joined: Tue Apr 26, 2022 2:06 pm

Re: Excel Datasource automatic refresh data

Post by acataluffi »

Hello,
i tried to set RefreshTime and add some data in my Excel File but the dashboard doesn't update the data, it only refresh itself.
The only way to update data is load a new excel datasource with updated data.


Thank you
Lech Kulikowski
Posts: 6197
Joined: Tue Mar 20, 2018 5:34 am

Re: Excel Datasource automatic refresh data

Post by Lech Kulikowski »

Hello,

Please send us a sample report with test data that reproduces the issue for analysis.

Thank you.
Post Reply