Alphabetical sort of a number of excel files in the directory
2 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Hello,
I have a bunch of excel xlsx files in a directory named like this:
Farbin Inc.xlsx
Younan Metal Works.xlsx
Shree Transport.xlsx
...
These primarily contain alphanumerical data. One of these columns contains entries (one in each row) whose sum is the total expenditure of the company, this is numerical data. The total expenditure is not listed separately (in any other column).
For some reason, a plot is desired in which the x-axis range is increasing alphabetically (based on the first alphabet of the name of the company), and the y-axis value is the corresponding expenditure. For example, Farbin Inc can be
160000
129700
100890
117520
134210
so that the total expenditure is the sum of these rows, i.e. $ 642,320.
It seems easy to read the files individually, and do the sum to obtain the expenditure value. But simply unable to obtain this required plot. How can such an alphabetical arrangement be obtained? Thanks.
Réponses (0)
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!