06-09-2017
Python soap and string to .xlsx conversion
Hi experts -
I'm relatively new to python, but I have an requirement to automate getting a file from a WebLib server using an API.
The file I'm requesting from this sever is an excel spreadsheet (.xlsx).
I get a valid response back via an xml doc from the server.
In this xml file I get back, within a tag pair a very long string that is supposed to represent the .xlsx file I'm requesting.
My problem is, I don't know how to convert this string back into an .xlsx so that I can look at its content.
Does anyone have any ideas on how to convert this “string” back into an excel document?
Thanks
---------- Post updated 06-09-17 at 09:40 AM ---------- Previous update was 06-08-17 at 09:46 AM ----------
Does anyone have any insight on how to convert this "string" into an excel document in python?
I would be happy with a good website I can research on python soap/api binary downloads.
Thanks!
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I am porting a awk script from Windows to unix
I_SALE_MEDIA=$67
if ((I_VOID_FLAG == "Y") && (I_SALE_MEDIA == 0))
NOW consider the case where I_SALE_MEDIA i.e $67 is "000"
The above comparison works fine in Windows , but to make it work in
Unix , I had to change the above as follows :
... (3 Replies)
Discussion started by: rohanrege
3 Replies
2. Shell Programming and Scripting
Guys
I need to convert a code from JSP (Java Tags are also there inside JSP) to PYTHON.
I have OK kind of knowledge in PYTHON, but dont have a muck knowledge in JAVA/JSP.
Any idea how to approach?
Thanks in advance to all
C Saha (1 Reply)
Discussion started by: csaha
1 Replies
3. Programming
Hello all. I need help...
How can I cenvert this 42ec93df826c804ea531c56594db453d54daad4b to normal text? What convertor I have to use?
Thanks. (12 Replies)
Discussion started by: escudo
12 Replies
4. Shell Programming and Scripting
Hi Guys,
The code snippet below is working fine with xls 2003 but the same is not working in xlsx 2007. Can someone please help.
#Convert .txt file format to .xls format
awk 'BEGIN{
FS="|"
cols=8
print "<HTML><style type=\"text/css\">td{mso-number-format:\"\@\"}</style><BODY><TABLE... (1 Reply)
Discussion started by: icefish
1 Replies
5. Shell Programming and Scripting
I have a file command.txt. It's content are as follows:-
The content of file is actually a command with script name and respective arguments.
arg1 and arg2 are dummy arguments , format : -arg arg_value
test is a argument specifying run mode , format : -arg
In my python code, i read it and... (1 Reply)
Discussion started by: animesharma
1 Replies
6. Shell Programming and Scripting
How to convert below bash code in perl and python.
for BLOCK in /sys/block/emcpow*
do
echo "100000" > "$BLOCK"/queue/nr_requests
echo "noop" > "$BLOCK"/queue/scheduler
done (2 Replies)
Discussion started by: learnbash
2 Replies
7. Shell Programming and Scripting
Hi,
I have a String say 20131224 which represents a date.
I want to to subtract 1 day from this.
Any idea how can i do this on AIX. (1 Reply)
Discussion started by: RahulM
1 Replies
8. UNIX for Advanced & Expert Users
Hi ,
I am having a ZIP file containing an .xlsx file . Now i wanted to replace "GJ" to blank in the .xlsx file .
I tried using the below code but not working , Please guide :
#!/bin/bash
log="/home/srikant/scripts/replacescriptFHO.log"
date > $log
echo "" >> $log
echo initiating for FHO... (1 Reply)
Discussion started by: vipinmaster
1 Replies
9. Programming
Hi. I have timestamps that I am trying to convert to epoch time. An example:
I am trying to convert this to an epoch timestamp but have one little glitch. I have this:
import time
date_time = ''
pattern = ''
epoch = int(time.mktime(time.strptime(date_time, pattern)))
print epoch... (1 Reply)
Discussion started by: treesloth
1 Replies
10. Programming
Is there a way to append an existing xlsx worksheet to add data from a text file ?
I have an excel file for which I need to manipulate the first worksheet based on a text file.
I match the text file to the xlsx and write the 'Scores' column in the xlsx sheet and save the workbook.
For those ... (43 Replies)
Discussion started by: nans
43 Replies
LEARN ABOUT DEBIAN
isympy
isympy(1) isympy(1)
NAME
isympy - interactive shell for SymPy
SYNOPSIS
isympy [-c | --console]
isympy [ {-h | --help} | {-v | --version} ]
DESCRIPTION
isympy is a Python shell for SymPy. It is just a normal python shell (ipython shell if you have the ipython package installed) that exe-
cutes the following commands so that you don't have to:
>>> from __future__ import division
>>> from sympy import *
>>> x, y, z = symbols("xyz")
>>> k, m, n = symbols("kmn", integer=True)
So starting isympy is equivalent to starting python (or ipython) and executing the above commands by hand. It is intended for easy and
quick experimentation with SymPy. For more complicated programs, it is recommended to write a script and import things explicitly (using
the "from sympy import sin, log, Symbol, ..." idiom).
OPTIONS
-c shell, --console=shell
Use the specified shell (python or ipython) as console backend instead of the default one (ipython if present or python otherwise).
Example: isympy -c python
FILES
${HOME}/.sympy-history
Saves the history of commands when using the python shell as backend.
BUGS
The upstreams BTS can be found at <http://code.google.com/p/sympy/issues/list> Please report all bugs that you find in there, this will
help improve the overall quality of SymPy.
SEE ALSO
ipython(1), python(1)
2007-10-8 isympy(1)