Excel and batch

[Rapid_Zorgz]

hey guys im new to batch programming and was wondering how i could create a batch file that opens a excel spreadsheet and then edits data in a certain column within a certain sheet

so
1) open a excel spreadsheet
2) target a certain column in a certain sheet
3) change data in that column
4) save it again


thanks in advanced

[Squashman]

Can't edit Excel files with Batch. You can with PowerShell though.

[Rapid_Zorgz]

thanks

[Rapid_Zorgz]

how would u do it with powershell can u use powershell and C#

[npocmaka_]

Can't edit Excel files with Batch. You can with PowerShell though.

Also with VBscript and JScript via excel's com objects (with which you can make hybrid files)



@Rapid_Zorgz what exactly do you need?

[Squashman]

how would u do it with powershell can u use powershell and C#

This isn't a PowerShell forum. You may want to find help somewhere else. I did this once many years ago as a one off using PowerShell. You might be able to find the thread on TechGuy.org.