How to process information on one excel spreadsheet and reformat the information onto another excel spreadsheet?

Question

Paul Badra 2024-3-19

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2096401-how-to-process-information-on-one-excel-spreadsheet-and-reformat-the-information-onto-another-excel

评论： Paul Badra 2024-3-30

Hi, I have an excel spreadsheet called RawExcel.xlsx which has 13 columns and 37 rows but not all of the information is needed. I would like to get rid of alot of information and condense it down to 5 columns.

How would I write code to do the following process:

Delete and remove Columns C, E, G, J, K, L, and M
Delete and remove all rows containing single and double digits under the FIND NO (Column 1)
Delete and remove second row and rewrite top row to FIND NO (Column 1), QTY (Column 2), PART NUMBER (Column 3), REF NUMBER (Column 4), and REF NUMBER (Column 5).
Under the new REF DESIGNATOR column, concatinate strings contained on row 31 and 32 to form 'J32, K131, K132, J34, K133'
Delete and remove all empty cells
Write remaining information into another excel called ProcessedExcel.xlsx

The information in the ProcessedExcel.xlsx should look like this:

Any help will be greatly appreciated.

2 个评论
显示无隐藏无

John D'Errico 2024-3-19

Surely this is better done using macros, not working in MATLAB at all?

Paul Badra 2024-3-19

Yes, macros could work for this portion..the thing is, there is more data i'm not showing that needs to be processed.

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

SAI SRUJAN 2024-3-25

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2096401-how-to-process-information-on-one-excel-spreadsheet-and-reformat-the-information-onto-another-excel#answer_1430496

Hi paul,

I understand that you are trying to process information on one excel spreadsheet and reformat the information onto another excel spreadsheet.

To achieve the described tasks using MATLAB, you can follow the steps below. This script reads data from RawExcel.xlsx, processes it according to your specifications, and then writes the processed data to ProcessedExcel.xlsx.

For a comprehensive understanding of reading data from an Excel sheet in MATLAB and utilizing table methods effectively, please go through the following relevant documentation.

https://www.mathworks.com/help/matlab/import_export/read-spreadsheet-data-into-table.html

https://www.mathworks.com/help/matlab/ref/table.html

I hope this helps!