Sponsored Content
Top Forums Shell Programming and Scripting Python soap and string to .xlsx conversion Post 302998833 by timj123 on Friday 9th of June 2017 10:40:54 AM
Old 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

String Conversion in awk

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

Code conversion from JSP to PYTHON

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

Hex string conversion?

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

Text to xlsx conversion

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

[python]string to list conversion

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

conversion of code in perl and python

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

String to Date conversion

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

Wanted to replace string in an .xlsx file in multiple ZIP Files

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

Python conversion to epoch time

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

Appending a column in xlsx file using Python

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
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)
All times are GMT -4. The time now is 03:13 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy