MATLAB Answers

Alphabetical sort of a number of excel files in the directory

21 views (last 30 days)
v k
v k on 15 Jan 2021
Commented: KSSV on 15 Jan 2021
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.

Answers (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!