Excel Datasource automatic refresh data
-
- Posts: 21
- Joined: Tue Apr 26, 2022 2:06 pm
Excel Datasource automatic refresh data
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
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
-
- Posts: 6245
- Joined: Tue Mar 20, 2018 5:34 am
Re: Excel Datasource automatic refresh data
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.
> 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.
-
- Posts: 21
- Joined: Tue Apr 26, 2022 2:06 pm
Re: Excel Datasource automatic refresh data
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
-
- Posts: 6245
- Joined: Tue Mar 20, 2018 5:34 am
Re: Excel Datasource automatic refresh data
Hello,
In the data source to the excel file is a specified path or added as a resource?
Thank you.
In the data source to the excel file is a specified path or added as a resource?
Thank you.
-
- Posts: 21
- Joined: Tue Apr 26, 2022 2:06 pm
Re: Excel Datasource automatic refresh data
Hi,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.
i get it as a file from file input
Thank u
-
- Posts: 6245
- Joined: Tue Mar 20, 2018 5:34 am
Re: Excel Datasource automatic refresh data
Hello,
You can set the RefershTime option for the dashboard to automatically update data.
Thank you.
You can set the RefershTime option for the dashboard to automatically update data.
Thank you.
-
- Posts: 21
- Joined: Tue Apr 26, 2022 2:06 pm
Re: Excel Datasource automatic refresh data
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
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
-
- Posts: 6245
- Joined: Tue Mar 20, 2018 5:34 am
Re: Excel Datasource automatic refresh data
Hello,
Please send us a sample report with test data that reproduces the issue for analysis.
Thank you.
Please send us a sample report with test data that reproduces the issue for analysis.
Thank you.