# Azure Automation / Sharepoint / Excel

**URL:** <https://forums.powershell.org/t/azure-automation-sharepoint-excel/11849>\
**Category:** PowerShell Help\
**Created:** [January 3, 2019, 11:42am UTC](https://forums.powershell.org/t/azure-automation-sharepoint-excel/11849 "2019-01-03T11:42:37Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![mortensummer](https://avatars.discourse-cdn.com/v4/letter/m/51bf81/32.png) [@mortensummer](https://forums.powershell.org/u/mortensummer)\
**Post date:** [January 3, 2019, 11:42am UTC](https://forums.powershell.org/t/azure-automation-sharepoint-excel/11849/1 "2019-01-03T11:42:37Z")

</div>

Hi All,

I have a task that requires me to periodically extract data from an excel file which stored on a sharepoint online site, and import it into a SQL Azure database.

I was thinking of doing this via Azure Automation / Powershell for maximum control.

I cannot find the exact answer online during my research, so hopefully someone has tackled a similar issue?

Can Powershell within Azure Automation use the Excel COM objects? My PoC code for accessing the Excel sheet functions on-premise, however it does use this Excel COM object to read the data.

If not, any other ideas on how best to tackle this issue? (i understand this maybe slightly outside of powershell q+a’s…so apologies!)

TIA

---

<div class="post-metadata">

**Author:** ![sam-boutros](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.powershell.org/sam-boutros/32/5_2.png) [@sam-boutros](https://forums.powershell.org/u/sam-boutros)\
**Post date:** [January 3, 2019, 2:06pm UTC](https://forums.powershell.org/t/azure-automation-sharepoint-excel/11849/2 "2019-01-03T14:06:17Z")

</div>

[https://www.powershellgallery.com/packages/ImportExcel/5.4.3](https://www.powershellgallery.com/packages/ImportExcel/5.4.3)

---

<div class="post-metadata">

**Author:** ![mortensummer](https://avatars.discourse-cdn.com/v4/letter/m/51bf81/32.png) [@mortensummer](https://forums.powershell.org/u/mortensummer)\
**Post date:** [January 3, 2019, 2:22pm UTC](https://forums.powershell.org/t/azure-automation-sharepoint-excel/11849/3 "2019-01-03T14:22:06Z")

</div>

Damn! I was stuck thinking natively… I didnt think about the PS gallery. And I note they have a “deploy to azure automation”… which is nice.

Sometimes the best answers are the simplest.

Thanks Sam!

&nbsp;

---

<div class="post-metadata">

**Author:** ![dotnVo](https://avatars.discourse-cdn.com/v4/letter/d/4af34b/32.png) [@dotnVo](https://forums.powershell.org/u/dotnVo)\
**Post date:** [May 16, 2024, 8:33pm UTC](https://forums.powershell.org/t/azure-automation-sharepoint-excel/11849/4 "2024-05-16T20:33:31Z")

</div>

Closed on May 16, 2024, 8:33pm UTC


