Reading files in from the proper directory

2012-02-07 Thread SMac2347
Hello. I am admittedly a Python novice, and ran into some trouble trying to write a program that will pull multiple excel files all into one file, with each file on a different sheet. I am confident most of the code is correct, as the program runs without any errors and I found the base of it onli

Re: Reading files in from the proper directory

2012-02-07 Thread SMac2347
Thanks for the responses. Below is the code I have thus far. while the program runs glitch-free, it only results in the printing of the message: "NOTE *** No xls files in C:/Documents and Settings/smacdon/." as specified by my code. Any idea as to why it might be unable to find the .xls documents

Re: Reading files in from the proper directory

2012-02-07 Thread SMac2347
On Feb 7, 1:40 pm, Dave Angel wrote: > On 02/07/2012 01:14 PM, smac2...@comcast.net wrote:> Hello. I am admittedly a > Python novice, and ran into some trouble > > trying to write a program that will pull multiple excel files all into > > one file, with each file on a different sheet. > > > I am

Re: Reading files in from the proper directory

2012-02-09 Thread SMac2347
On Feb 7, 3:16 pm, Peter Otten <__pete...@web.de> wrote: > smac2...@comcast.net wrote: > > xls_files   = glob.glob(in_dir + "*.xls") > > Try changing that to > > pattern = os.path.join(in_dir, "*.xls") > xls_files = glob.glob(pattern) > > os.path.join() inserts a (back)slash between directory and f

Re: Reading files in from the proper directory

2012-02-09 Thread SMac2347
On Feb 7, 3:16 pm, Peter Otten <__pete...@web.de> wrote: > smac2...@comcast.net wrote: > > xls_files   = glob.glob(in_dir + "*.xls") > > Try changing that to > > pattern = os.path.join(in_dir, "*.xls") > xls_files = glob.glob(pattern) > > os.path.join() inserts a (back)slash between directory and f

Python to Combine Multiple Excel Worksheets into One Worksheet

2012-02-15 Thread SMac2347
Hello, I have one single Excel file with many separate worksheets, and for work I need to combine all these separate worksheets into one single worksheet (I am not worried about formatting, as the format is the same in each sheet, nor am I worried about Excel's row limit). Essentially, I am lookin

Python and Bloomberg

2012-04-03 Thread SMac2347
Hello, I was just wondering if anyone had experience using Python to interact with Bloomberg. Ideally, I'd look to use Python to feed Bloomberg's OVML calculator with a list of inputs, and then use an additional program to grab the results of the calculator for each calculation, and pull them into

Web Scraping - Output File

2012-04-26 Thread SMac2347
Hello, I am having some difficulty generating the output I want from web scraping. Specifically, the script I wrote, while it runs without any errors, is not writing to the output file correctly. It runs, and creates the output .txt file; however, the file is blank (ideally it should be populated

Re: Web Scraping - Output File

2012-04-26 Thread SMac2347
On Apr 26, 2:19 pm, Kiuhnm wrote: > On 4/26/2012 19:54, smac2...@comcast.net wrote: > > > > > > > > > > > Hello, > > > I am having some difficulty generating the output I want from web > > scraping. Specifically, the script I wrote, while it runs without any > > errors, is not writing to the outpu

HTML Code - Line Number

2012-04-27 Thread SMac2347
Hello, For scrapping purposes, I am having a bit of trouble writing a block of code to define, and find, the relative position (line number) of a string of HTML code. I can pull out one string that I want, and then there is always a line of code, directly beneath the one I can pull out, that begin