Excel automation

[Adil]

Are there any good (progammatic) ways of automating spreadsheet creation in Excel? I'm currently copying and pasting the output of 4 SQL queries into a spreadsheet manually; ideally I'd be able to automate this and then run a monthly job to generate the spreadsheets.

I know there's a way to access PGSQL databases from Excel (power query) but is there a way to generate a spreadsheet based off some SQL queries?

 

[M8than]

You could use a scripting language like python or php?

 

[Adil]

You could use a scripting language like python or php?

yeah ethereal recommended a python library for xlsx manipulation

think I'll just use that

thanks!