csv - Excel 2013: Automatic data update from external URL -
i have webservice continuously generate/update csv file can downloaded externally. use excel file continuously content of csv file, , calculation , visualization accordingly.
e.g. csv file contains 4 rows, 3 columns. in excel sheet, a1:c4 used store contents of csv file. a5:c5 average of each column. , bar chart of contents in each column displayed in a5.
how can ask excel download csv file specifying url, , store in a1:c4? , how make automatically update contents when csv file updated?
Comments
Post a Comment