Peter B
125 ●10 ●13 ●19

I see that previously a question was asked about how to automate the export of ACCC results to excel. I can manage the export part.

What I can't figure out is how to name the output excel file via a GUI that shows the directory the file is to be saved in (this is useful as a memory prompt for previously used naming conventions etc).

I've tried using

import tkFileDialog filename = tkFileDialog.askopenfilename()

and

import tkFileDialog filename = tkFileDialog.asksaveasfilename()

In various different ways without success. Any ideas?

edit retag flag offensive close merge delete

Comments

OK so I've largely figured this out myself.

Peter B ( 2012-07-30 20:02:52 -0500 )edit

Arrgh! I want to add a space and it keeps posting! Anyway I've largely figured this out myself. If someone can tell me how to paste code such that it looks readable and isn't jumbled in as normal txt I'll put it up. There is a bug though which I will also explain.

Peter B ( 2012-07-30 20:06:21 -0500 )edit

For an inline code snippet, you can surround the code in backticks ( ` ). For a code block, the code needs to be indented from the normal text. You can also use the "101..." button in the editor toolbar to do this for you. Nice work btw.

Daniel_Hillier ( 2012-07-31 09:06:36 -0500 )edit

Hi there! We would love to see the code.

amaity ( 2012-07-31 12:07:45 -0500 )edit

import tkFileDialog, ntpath filetypes = [('Excel Workbook', '*.xlsx'),('All Files','*.*')] filenamesaveas = tkFileDialog.asksaveasfilename(filetypes=filetypes, title='Results Workbook Name') xlsfilename = ntpath.basename(filenamesaveas)

Peter B ( 2012-07-31 20:35:27 -0500 )edit

see more comments

import Tkinter, tkFileDialog, ntpath root = Tkinter.Tk() root.withdraw() filetypes = [('Excel Workbook', '*.xlsx'),('All Files','*.*')] filenamesaveas = tkFileDialog.asksaveasfilename( filetypes=filetypes, title='Results Workbook Name') xlsfilename = ntpath.basename(filenamesaveas)

Comments

Hi Peter, does this show the correct directory when you run it, or does it always use the same default directory?

JervisW ( 2012-08-01 02:25:06 -0500 )edit

It always shows the directory that the python script is in, which is what I was trying to do. If one wanted it to show the directory that the .sav case is in (if it isn't also in the same directory as the python script) that would take some extra tweaking.

Peter B ( 2012-08-01 18:18:56 -0500 )edit

add a comment

How to name ACCC excel results

Comments

1 answer

Comments

Your Answer

Question Tools

Stats

Related questions