# Error Font (Vietnamese) When import to power table in ignition

**URL:** <https://forum.inductiveautomation.com/t/error-font-vietnamese-when-import-to-power-table-in-ignition/73632>\
**Category:** Ignition\
**Tags:** ignition81\
**Created:** [May 12, 2023, 3:45am UTC](https://forum.inductiveautomation.com/t/error-font-vietnamese-when-import-to-power-table-in-ignition/73632 "2023-05-12T03:45:46Z")\
**Posts on this page:** 1\
**Showing post:** 6

<div class="post-metadata">

**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:** [May 15, 2023, 10:45am UTC](https://forum.inductiveautomation.com/t/error-font-vietnamese-when-import-to-power-table-in-ignition/73632/6 "2023-05-15T10:45:02Z")

</div>

Your spreadsheet doesn't really lend itself well to creating a dataset with the way the headers are arranged. Merged cells don't exist in datasets, either.  
I recommend moving / removing items that are not related to the dataset.

[Production Plan-revised headers.xlsx](https://forum.inductiveautomation.com/uploads/short-url/lsoJSQiXIdlEl3S1MTuFJsKwkdU.xlsx) (15.2 KB)

I was then able to import directly from the excel file. using the function provided here:

> [@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…

```python
path = system.file.openFile('xlsx')
dataset = util.excelToDataSet(path, hasHeaders = True, firstRow = 2, firstCol = 1, lastCol = 9)
event.source.parent.getComponent('Power Table').data = dataset

```

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/5/f5d659c5c5f5c746513eb4b43fab1a9b971deb83.png)

---

_[View the full topic](https://forum.inductiveautomation.com/t/error-font-vietnamese-when-import-to-power-table-in-ignition/73632)._