search

Emurasoft / excel-csv-import

An Excel add-in for importing and exporting CSV files
https://www.emeditor.com/
MIT License
13 stars 3 forks source link

ADD-IN error when try to add it to Excel Windows #89

Closed hwasiti closed 3 years ago

hwasiti commented 3 years ago

I am getting this error when I click on trust this addon in Excel 2016 on Windows 10: Excel Add-in error we can't load this add-in because we couldn't connect to the catalog

I tried the same steps on Mac and it worked. Any other method to add this addon to my Windows Excel?

Do you have the compiled file that I can download and manually add it? I have added some add-ins before manually this way. Appreciate if you have the compiled file. I don't have the expertise to compile it from the source code.

MakotoE commented 3 years ago

Try using Excel Online by going to https://www.office.com/, signing in, and opening the Excel app. Add the add-in from there.

You mentioned that you added add-ins manually; is this because you got the same error in other add-ins as well?

hwasiti commented 3 years ago

Try using Excel Online by going to https://www.office.com/, signing in, and opening the Excel app. That should work, but I prefer the offline excel for large data sheets.

is this because you got the same error in other add-ins as well?

Not really.. I remember that add-in (Unicode CSV) has only this manual method and not through the Microsoft store.

I think I got it from here

Your add-in is better since it allows me to customize the separator as well.

MakotoE commented 3 years ago

If you want to add this add-in without the add-ins catalog, you'll have to host it on your localhost, as described in this tutorial. That means I can't just share the compiled files, you will need some kind of http server. It's easiest to just get node, compile it, and use webpack to host it.

Sorry but I don't have Excel 2016 so I am not supporting that version.

If you have a large data sheet, I would export it as either a CSV file and open it with a text editor, or export it to a SQL database.

hwasiti commented 3 years ago

Sorry but I don't have Excel 2016 so I am not supporting that version.

In the mac where it worked the Excel was v.2019. So indeed maybe the issue with Excel 2016.

If you have a large data sheet, I would export it as either a CSV file and open it with a text editor, or export it to a SQL database. Eventually, I went through that route. I was just a bit lazy and wanted to do it in Excel :) I used pandas and python which was super fast. But I was still interested in your add-in for the future. When I will update to Excel 2019, maybe it will work.

Thanks for your replies and support.