![]() ![]() You'll need some logic to match Worksheets on name, or number, or count of rows / columns within, as they may have changed the order / renamed).Īnother quick hack and you could compare the Value and then the Format of every Cell in matching tow Worksheets. ![]() ![]() If XLS rather than XLSX, then example on the Spreadsheet::ParseExcel page will do a portion of that you want, walk every cell, sheet by sheet and row by row in a workbook, if you need the XLSX support see the links on the page.Īnyway a simple tweak to open a second workbook and you could create a tool that compares Worksheet names and the number, along with the maximum column and row counts in each Worksheet, a few min's, only outputting something if there's some inequality. If you have the time and know a bit of Perl you could create your own tool in an hour or two. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |