[Solved] Read data from a series of external spreadsheet fil

Creating a macro - Writing a Script - Using the API

[Solved] Read data from a series of external spreadsheet fil

Postby Tanker3278 » Sat May 08, 2021 7:01 am

Hi everyone!

GOAL: I'd like to write some basic code to loop through all the files (their all in the same directory), find the column that has the parts in it, then go down that column and write that data to a new spreadsheet while sorting the parts into category by sheet. Meaning each category of part has it's own sheet, all the hydraulic stuff is on one sheet, all the material stuff is on another sheet.

BACKGROUND INFO: I have about 30 spreadsheets I've converted to OO Calc files since I'm not going to give MS part of my income every month with that subscription crap.

All the files have the data format, but some of the older ones have a different column arrangement (before I figured out what works best for me). Column C is currently the column for part numbers. The first character in the part number is a category identifier ("h" = hydraulic, "e" = electrical, "m" = materials, "a" = automotive, etc, etc).

I had a very limited amount of experience with VBA in excel from a few years ago. I would not call myself anything beyond a novice. I had a couple of C++ classes back in college (20 years ago). I am actively trying to play with Calc Basic to learn and become more proficient.

Thanks!
-Jimmy
Last edited by Hagar Delest on Sat May 08, 2021 4:22 pm, edited 1 time in total.
Reason: tagged solved.
OpenOffice 4.1 on Windows 10.1
Tanker3278
 
Posts: 2
Joined: Sat May 08, 2021 6:20 am

Re: Read data from a series of external spreadsheet files

Postby Villeroy » Sat May 08, 2021 9:48 am

Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
Villeroy
Volunteer
 
Posts: 29887
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Read data from a series of external spreadsheet files

Postby Tanker3278 » Sat May 08, 2021 4:07 pm

Vielen Dank!
OpenOffice 4.1 on Windows 10.1
Tanker3278
 
Posts: 2
Joined: Sat May 08, 2021 6:20 am


Return to Macros and UNO API

Who is online

Users browsing this forum: No registered users and 6 guests