# How to Open Excel file to view in Ignition Graphics **URL:** \ **Category:** Ignition\ **Tags:** vision\ **Created:** [June 13, 2023, 11:16am UTC](https://forum.inductiveautomation.com/t/how-to-open-excel-file-to-view-in-ignition-graphics/74950 "2023-06-13T11:16:30Z")\ **Posts on this page:** 1\ **Showing post:** 2
**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\ **Post date:** [June 13, 2023, 11:18am UTC](https://forum.inductiveautomation.com/t/how-to-open-excel-file-to-view-in-ignition-graphics/74950/2 "2023-06-13T11:18:39Z")
> [@Copying an Excel file to a table's dataset](https://forum.inductiveautomation.com/t/copying-a-excel-file-to-a-tables-dataset/34942/13): > > Got my paperwork done early, so here's a sample to read from an Excel file EDIT: Reworked a bit to work with both .xls and .xlsx files EDIT: Modified to properly cast data types EDIT: Added handler for formula cell types EDIT: Added parameters to optionally specify sheet, row, and column numbers Reading back a file created from my other example: def excelToDataSet(fileName, hasHeaders = False, sheetNum = 0, firstRow = None, lastRow = None, firstCol = None, lastCol = None): import org.apac… > [@Ignition Extensions - Convenience utilities for advanced users](https://forum.inductiveautomation.com/t/ignition-extensions-convenience-utilities-for-advanced-users/64615): > > Introducing a hopefully community-engaged effort to build a useful repository of scripting and other Ignition utilities for everyone to benefit from. Download the latest release from the [Releases](https://github.com/IgnitionModuleDevelopmentCommunity/ignition-extensions/releases) page and take advantage of the following functions: Scripting Functions system.util system.util.getContext(): Context A convenience function to retrieve the local "context" object, useful as an entrypoint to other advanced scripting. system.util.deepCopy(object): Object Converts a given Python obj… --- _[View the full topic](https://forum.inductiveautomation.com/t/how-to-open-excel-file-to-view-in-ignition-graphics/74950)._