Re^3: Transistor Counting from Excel Sheet.

Replies are listed 'Best First'.
Re^4: Transistor Counting from Excel Sheet. by pryrt (Abbot) on Feb 06, 2018 at 14:52 UTC
We'd love to help you. But the way you've asked looks to ((some\|many\|most) of) us like "please do my homework for me" or "please do the job that I'm paid to do for me, but without me offering to pay you" or "I'm too lazy to try to learn how to do what I want to do, so I'm going to try to convince someone to do it for me." Even if that's not what you were intending, that's what it came across as, to at least a portion of the monks here. If, instead, you want to learn (which is, I hope, why you came here), then ++hippo's outline is a really good starting point. To give you a further boost on #1: to design the algorithm, the best place to start is by giving a detailed answer to "how would I accomplish this task manually?" The steps would start out as something like: "open the spreadsheet", "open the report document", "find the name of the first cell from inside the report", "count the number of instances of that name in the spreadsheet", etc. Then you would have to fill in details, giving specifics of how you would manually do each of those steps: for example, to manually "open the spreadsheet", you might say "run `excel.exe c:\path\to\filename`", or you might say "run Excel, then use File\|Open to select the `c:\path\to\filename`", or you might say "double click on `c:\path\to\filename` to activate its default associated action". Or you might realize that you don't need to use excel itself, since many tools (including modules in Perl, like Spreadsheet::ParseExcel that ++roboticus suggested) are able to read excel spreadsheets, so you might say "use some tool inside Perl to open the file, with the ability to read through contents. Once you have a detailed manual procedure, you would need to learn enough perl (the Perl Monks' [id://Tutorials] is a good place to start) to be able to start expressing that in Perl syntax. Also, if you asked nicely for recommendations of modules to use, we could point you to Spreadsheet::ParseExcel, and similar for reading and writing the report .docx: for example, this SO reply suggests using Win32 modules if you're on Windows, or Text::Extract::Word, though that doesn't appear to handle the more modern .docx format. this thread talks some more about accessing Word documents from linux-based perl. Other Monks may know of more recent modules that give better direct access to the Word document. PerlMonks is not a code writing service, but many monks often write complete solutions for simple problems -- they just usually don't do that until the original poster has put in some effort of giving a detailed description of what they want, preferrably with code that makes a reasonable attempt, even if it doesn't succeed (with good sample data showing what your input is, what you get out, and what you really want to get).	[reply] [d/l] [select]

Replies are listed 'Best First'.

Re^4: Transistor Counting from Excel Sheet.
by pryrt (Abbot) on Feb 06, 2018 at 14:52 UTC

We'd love to help you. But the way you've asked looks to ((some|many|most) of) us like "please do my homework for me" or "please do the job that I'm paid to do for me, but without me offering to pay you" or "I'm too lazy to try to learn how to do what I want to do, so I'm going to try to convince someone to do it for me." Even if that's not what you were intending, that's what it came across as, to at least a portion of the monks here.

If, instead, you want to learn (which is, I hope, why you came here), then ++hippo's outline is a really good starting point. To give you a further boost on #1: to design the algorithm, the best place to start is by giving a detailed answer to "how would I accomplish this task manually?" The steps would start out as something like: "open the spreadsheet", "open the report document", "find the name of the first cell from inside the report", "count the number of instances of that name in the spreadsheet", etc. Then you would have to fill in details, giving specifics of how you would manually do each of those steps: for example, to manually "open the spreadsheet", you might say "run excel.exe c:\path\to\filename", or you might say "run Excel, then use File|Open to select the c:\path\to\filename", or you might say "double click on c:\path\to\filename to activate its default associated action". Or you might realize that you don't need to use excel itself, since many tools (including modules in Perl, like Spreadsheet::ParseExcel that ++roboticus suggested) are able to read excel spreadsheets, so you might say "use some tool inside Perl to open the file, with the ability to read through contents.

Once you have a detailed manual procedure, you would need to learn enough perl (the Perl Monks' [id://Tutorials] is a good place to start) to be able to start expressing that in Perl syntax. Also, if you asked nicely for recommendations of modules to use, we could point you to Spreadsheet::ParseExcel, and similar for reading and writing the report .docx: for example, this SO reply suggests using Win32 modules if you're on Windows, or Text::Extract::Word, though that doesn't appear to handle the more modern .docx format. this thread talks some more about accessing Word documents from linux-based perl. Other Monks may know of more recent modules that give better direct access to the Word document.

PerlMonks is not a code writing service, but many monks often write complete solutions for simple problems -- they just usually don't do that until the original poster has put in some effort of giving a detailed description of what they want, preferrably with code that makes a reasonable attempt, even if it doesn't succeed (with good sample data showing what your input is, what you get out, and what you really want to get).

[reply]
[d/l]
[select]