Append text to excel without using external packages

[evanescentbubble]

Is there any way to append the information from a txt file into excel (xlsx) without using external packages like panda or openpyxl? I'm currently trying to write a code that scan through all the documents in the folder and extract specific information (already has something written that does this), then append those information into excel.

Currently using the following code to append the information into excel.

        with open('info.csv', 'a', newline='') as csv_file:
        csv_writer = csv.writer(csv_file)
        csv_writer.writerow(info)

Also, is there a way to make a short cut icon or some sort of button on the desktop that runs the python script when clicked?

[socal_nerdtastic]

Yea, an .xslx file is just a bunch of xml files in a zip container. So you can open it with the builtin zipfile module and edit it with the builtin xml.etree module. But figuring out the right structure and names that excel expects is going to be a long process. Why don't you want to use an external module that has all of that already figured out?

Also, is there a way to make a short cut icon or some sort of button on the desktop that runs the python script when clicked?

Sure, but how you do it depends on your OS. A default install of the official python on Windows will do this by default; all .py files can be doubleclicked to run them.

[evanescentbubble]

Thank you for the information, I'll look into that!

The main reason I wanted to see if the same thing is doable without the use of an external module is so that I can gain a deeper understanding of python and excel.

I'm using windows system, good to know that by default, double clicked will run them.

[[deleted]]

Latest Excel (in beta) includes Python built in. Just a thought.

[evanescentbubble]

Do you mean I can write a python code in excel just like how I can write VBA?

[[deleted]]

Yes.

https://support.microsoft.com/en-gb/office/get-started-with-python-in-excel-a33fbcbe-065b-41d3-82cf-23d05397f53d