PowerShell Tutorials Excel Module : Combining data from multiple sheets

In this video I go over how to take in a single file with multiple sheets, and combine the data in 3 different ways with scenarios that you could use each one for using the import excel module.
Tags:
PowerShell
Excel
Programming
Scripting
Automating
JackedProgrammer
Coding

[@sunset203]

From a text file I want to import the information into an Excel box to fill in certain set fields. Is it possible to do that?.
Thanks!

[@jgd6460]

Excellent : thanks !

[@jackedprogrammer]

Thank you, glad you're enjoying the videos :)

[@sergioblanco4504]

Hi, great video! Still have a question though, if you had two excel files and each file has a column that can be used as the primary key to join all the columns in both excel files into a single variable. How could this be done assuming that Column A has the data with the primary key. I tried importing both excel files into separate variables and using foreach bring them together but that didnt work. Appreciate the help. Thank you.

[@jackedprogrammer]

Thank you I'm glad you enjoyed the video, I noted this down and I will be making a video on combining 2 files together and ill have an example of using a primary key from both to combine the data :)

[@mohammadshakeer7206]

Hello,
Its great help watching your tutorial videos to carry out day to day tasks.
I am here today to ask if you can help me with Exporting data to SQL table using powershell.
Example- I have imported data from excel file to powershell in a variable now I want to write the same data to SQL tables is that way possible??
Awaiting your response

[@jackedprogrammer]

Glad you're enjoying the videos I actually have videos for inserting data into SQL its a multipart series here is the section for inserting : ruclips.net/video/log40KhckOE/видео.html
The first video of the series is this one : ruclips.net/video/iqxUDEEWbbo/видео.html
Let me know if this helps you at all or if you have a question :)

[@tanmoysaha3929]

Excellent, great idea. also, can you please share the code how to use Power Shell to upload file from my system into Ftp server directly from excel vba, thanks

[@MrCthrower]

How would you do it if you were using two different workbooks and then combining into one using data from each of the other two?

[@marcostdb7]

Alguem me ajuda ?
quando eu edito um arquivo excel com uma sheet ele funciona, porem, quando coloco um arquivo com duas sheets ele da erro.
Exceção ao chamar "Save" com "0" argumento(s): "Error saving file
No C:\Program Files (x86)\WindowsPowerShell\Modules\ImportExcel\7.8.6\Public\Export-Excel.ps1:686 caractere:20
+ else { $pkg.Save() }
+ ~~~~~~~~~~~
+ CategoryInfo : NotSpecified: (:) [], MethodInvocationException
+ FullyQualifiedErrorId : InvalidOperationException