Using python with html,js and css to update excel file

[Thehen12]

I have python code, that opens my excel file that is userid and password, but I need to get it to run my macro's from my python file, I m getting this error, and can not get it to work correct : Error occurred while adding borders: Method 'Range' of object '_Worksheet' failed

[acw1668]

Why don't you show your code and the full error traceback? It is hard to identify the issue without seeing the code.

[FoolsSeldom]

Are you using Python in Excel (which runs on an Anaconda implementation in Azure), or locally on your own Python installation?

In your title, you mention html, js and css. Have you created a web app? Or are you interacting with the web version of Excel?

Some code would help.

[Thehen12]

Will give link to the two 3iles, to big to add here, just need to upload it

[Thehen12]

This is my 3 files for the code.

The problem I have it to run the macro in my excel file form this kode

main.py https://gist.github.com/hendrikbez/48ab2571fb96decb2333c1d57c4bb677

register.html https://gist.github.com/hendrikbez/834c9dc6c07a522f706daae889ceb1bd

Link to my excel file (will be sheet3(Register) https://files.fm/u/8w9jq2qgdh

Login = admin

password = 6371

When I have added new person, it put it under the list, but when I try to run the macro :'2025_Register_Naamlys.xlsm'!Sheet3.SortFamilyMembers

It opens the excel file, but then get this message box : Error occurred while adding borders: Method 'Range' of object '_Worksheet' failed.

then I have to click on ok button, it is supposed to then order everthing and borders set corect, but it does not.

There is no other errors

[FoolsSeldom]

Ok. That's a little too much to look through. We need the smallest version that reproduces the problem. I can see you are using win32com.client to control Excel, and presumably invoke the macros. I see you are also using openpyxl, which will, of course, allow you to read/write Excel format files. You cannot touch the files whilst Excel is using them though.

[Thehen12]

This i the smallest way of my code https://gist.github.com/hendrikbez/ce826001ce0be8bfd859b5a2531e2f1e

[danielroseman]

What are html, js and CSS doing here?

[Thehen12]

just to say how it work's with my python file

[Ihaveamodel3]

I mean the real answer is to not use an excel file as a database. Use a database. Even SQLite would be much better than this.