User-created excel file (use case) not able to load

[JunejaAmmy]

I have created an excel file and tried to load it using method andes.load.

Below is the user-created file.
dpf_full.xlsx

Below is the screen shot of the error.

Please guide us, how to work with user-created file.

[cuihantao]

You can start with an example excel file in any of the andes/cases directories. For example, andes/cases/kundur/kundur_full.xlsx shows that you will need Bus, Line, and others as separate spreadsheets.

[JunejaAmmy]

Thanks Cui,

I want to test with my own excel file. I have attached my file as well. Please guide me if that is possible to load as an example excel file in any of the andes/cases directories.

[cuihantao]

You will need to check the examples and fix the difference.

[cuihantao]

How to load an example Excel file in andes/cases directory can be found in the notebook examples at https://github.com/cuihantao/andes/tree/master/examples

[JunejaAmmy]

Do we need to keep the same format (like headers, input-data) as in example file?

[cuihantao]

You will need to have the same structure as any of the examples. That is, bus information on a separate Bus sheet, line information on a Line sheet, etc.