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
ns_getmimetype
Ns_Mime(3aolserver) AOLserver Library Procedures Ns_Mime(3aolserver)
__________________________________________________________________________________________________________________________________________________
NAME
Ns_GetMimeType - Return the MIME type of a file
SYNOPSIS
#include "ns.h"
char *
Ns_GetMimeType(char *file)
_________________________________________________________________
DESCRIPTION
Ns_GetMimeType(file)
The Ns_GetMimeType function uses the extension of file and looks up the associated MIME type stored internally in the server. Case
is ignored. The return value is of the form "text/html".
AOLserver has a set of predefined file extension to MIME type associations. You can add to these associations by defining file
extension to MIME type associations in the server configuration file in the ns/mimetypes section. If you define a file extension
that already exists in the server, that file extension and MIME type association will be replaced with yours.
If no MIME type association exists for a particular file extension, or there is no file extension, the default and noextension MIME
types are returned, respectively. These default to "*/*" but can be set in the server configuration file.
Here is an example ns/mimetypes section from the server configuration file:
ns_section "ns/mimetypes"
ns_param ".doc" "application/msword"
ns_param ".ppt" "application/vnd.ms-powerpoint"
ns_param ".xls" "application/vnd.ms-excel"
ns_param ".cab" "application/mscabinet"
ns_param ".frl" "application/x-perfpro"
ns_param ".max" "application/vviewer"
ns_param ".mif" "application/x-mif"
ns_param ".frz" "application/x-dffill"
ns_param ".asvg" "image/svg-xml"
ns_param ".asvgz" "image/svg-xml"
ns_param ".svg" "image/svg-xml"
ns_param ".svgz" "image/svg-xml"
ns_param default "*/*"
ns_param noextension "*/*"
SEE ALSO
nsd(1), info(n)
KEYWORDS
AOLserver 4.0 Ns_Mime(3aolserver)