PowerShell Tutorials Excel Module Part 1 : Install / Basic Import & Export

[@DougFinke]

Nice tutorial! Glad you like my module, curious, the `-Show` switch, does that work with Libre Office? -Show tries to launch the xlsx using `Invoke-Item` which uses the default app to the file extension

[@jackedprogrammer]

Thank you Doug! It’s a great module I’ll give that a try I still had the office click to run as my default app for xlsx so I’ll set libre office as the default app and see and I’ll comment back to let you know, thank you for making such a great module :)

[@DougFinke]

@@jackedprogrammer What is a good way to private message you? Twitter DM, email? Happy either way or other

[@jackedprogrammer]

@@DougFinke hi Doug I do on my channel page I have a contact me which sends me an email and I check it multiple times daily :)

[@DougFinke]

@@jackedprogrammer yeah, was hoping to have more of a private conversation from my side, if you're comfortable with that. No worries if not :)

[@jackedprogrammer]

@@DougFinke for sure send me an email I’m open to it :)

[@bigshrestha]

Great video. Do you know how can we convert the excel date which is coming as 45216 to real date format? Thanks.

[@bobholder]

I am trying to used your technique to change a xls file into a csv file to be loaded into a SQL table. I am specifically using this because we do not want a copy of Excel on our server. How would I go about writing this code?

[@hulstie]

Should be a simple pipe to Convertto-CSV id imagine

[@bongadywili5974]

Great video, I wanted to find out how can you export excel and give it new headernames, similar to what you do with -HeaderName in Import-Excel

[@andersdose7038]

Another great video. Thanks.

[@AakashPatel-hs3cn]

you are awesome.

[@natanaelmuniz9348]

Great video! Thanks

[@krzysztofformella]

Great Video! Please add one movie about import Excel into SQL ;)

[@jackedprogrammer]

Thank, and I noted down the idea for me to create that video :), glad you're enjoying the videos

[@nikulvyas4987]

What if the top column has merged heading and the actual table headers starts from 3 row?