Hi, is there a simple way to convert the xls file to txt file to fit my program's code. import matplotlib.pyplot as plt x = [] y = [] t = [] fig = plt.figure() rect = fig.patch rect.set_facecolor('#31312e') **readFile = open('data.xls', 'r') sepFile = readFile.read().split('\n') readFile.close()** for idx, plotPair in enumerate(sepFile): if plotPair in '. ': # skip. or space continue if idx > 1: # to skip the first line xAndY = plotPair.split(',') time_string = xAndY[0] t.append(time_string) y.append(float(xAndY[1])) ax1 = fig.add_subplot(1, 1, 1, axisbg='blue') ax1.plot(t, y, 'c', linewidth=3.3) plt.title('IRRADIANCE') plt.xlabel('TIME') plt.show()

Member Avatar
Member Avatar
+0 forum 1

Hello I am using jxls quite fine. I'm sort of on my last lap with exporting my data to a file. However all I want to know is, how do I display my collection in the same row please? I've manage to do this downwards in the same column, but I'm not sure how to display them across in the same row. There website telss me how to do multiple collections across, but not one. Oy. I hope someone has an idea, because it "seems" simple enough.....seeems, but I judt don't tknow the syntax.

Member Avatar
Member Avatar
+0 forum 1

import xlrd import re workbook=xlrd.open_workbook('planningSpreadSheet_20140120T124023_20140203-20140209.xls') sh=workbook.sheet_by_index(0) palabras=str(sh) for col in range(sh.ncols): for i in range(sh.nrows): caca=sh.row_values(i) print(caca) Hi , i try to do a seeker, read an xls file ,and find a word,(input()),and show all the content of the row

Member Avatar
Member Avatar
+0 forum 1

Read first row from csv file and create table automatically according to it(csv file fields) in mysql. Looking for PHP script? I have tried this. <?php $arr = array(array(),array()); $num = 0; $row = 0; $handle = fopen("./contacts.csv", "r"); while($data = fgetcsv($handle,1000,",")){ $num = count($data); for ($c=0; $c < $num; $c++) { $arr[$row][$c] = $data[$c]; } $row++; } $con = mysql_connect('localhost','root',''); mysql_select_db("excel_database",$con); for($i=1; $i<$row; $i++){ $sql = "INSERT INTO contacts VALUES ('".$arr[$i][0]."','".$arr[$i][1]."','".$arr[$i][2]."','".$arr[$i][3]."','".$arr[$i][4]."','".$arr[$i][5]."')"; mysql_query($sql,$con); } ?>

Member Avatar
Member Avatar
+0 forum 1

Hi, We have a intranet with thousands of excel spreadsheets, we have set all the browsers so they open any excel spreadsheet in excel itself not within the browser which is how we wanted it all, unfortunately someone has now developed a spreadsheet they would like to open in the browser but it is only needed for this one spreadsheet is there any way o forcing it please Regards Matthew Clay

Member Avatar
Member Avatar
+0 forum 1

Thanks in advance Shanti

Member Avatar
Member Avatar
+0 forum 6

Hello friend, I have a registration form and a admin panel for that, In admin panel we can see the list of registered users. I can filter user details by search but i cannot export searched results to .xls or .csv format. kindly help me...!!! Thank you.

Member Avatar
Member Avatar
+0 forum 2

Hi, People... I have a question about reading xls files in python then parsing it to sqlDatabase. The thing is, that the xls file(pricelist) we as a company use are ordered and it's pretty easy to sort that out. The problem comes with xls files from other companies. (We are a laptop repair/sales company.) Example: Our Pricelist have names for each col_index and each row_index contain the specs(info) for the laptop -Make--------Model------Price------Bla -HP ---------DV6000-----R10 -------bla -Acer--------TM8100-----R20 -------bla The other companies... don't Theirs would have 3 cols, or more and rows would differ aswell asin it looks like a freaking news …

Member Avatar
Member Avatar
+0 forum 9

So, I'm currently trying to open a .xls/.xlsx file, tell it to run a macro to refresh the workbooks, and then save the file as a different file name, thus leaving the original untouched. Now, technically, it is working, because the last person who held my position wrote a dll to handle the interation. However, it leaves everything declared as an object, which is great up until you have someone who programs option strict on, option explicit on. Then I can't declare my objects at the last minute, and the whole assembly falls apart. It also sometimes falls apart anyway. …

Member Avatar
Member Avatar
+0 forum 4

header("Content-type: application/msexcel"); header("Content-type: text/msexcel"); header("Content-Disposition: attachment; filename=bulkUpdate.xls"); $out = ''; $out .='code'; $out .="\t"; $out .='sold'; echo $out; exit; in above code xls file is generated but getting output from second row .i want it from first row

Member Avatar
Member Avatar
+0 forum 1

Hi everybody. I have a simple problem. Need send the c++ output to excel(csv->xls or xls direct) in formated data. I can send the data to excel, but i can´t format that like this: |_ col 1__|___col 2___|___col n____| row 1......|....2row 1 row 2......|....2row 2 row 3......|... 2row n What i can´t, is go to begin in col 2. My code put the data in this way. |_ col 1__|___col 2___|___col n____| row 1 row 2 row n 2row1 2row2 2rown I don´t set this pointer to next columns. If i put the data in the same "for", i can …

Member Avatar
+0 forum 0

I have a working code that exports the datagrid into XLS. However, the datagrid results does not show on my aspx (html) page. It only shows on the page when I comment out the part that exports it to xls. I am not sure whether it should show by default when exporting. Basically, what I want to have is when I click my export button, it should display the datagrid on the page as well as popup an excel "open, save, cancel" window for the export. Here is my function for referece: [CODE]Public Sub Convert(ByVal ds As DataSet, ByVal Response …

Member Avatar
Member Avatar
+0 forum 3

hi, how to call exe file with some parameters from java and save the output of the exe file in a specified path. Please let me know immediately..its urgent!!! I am using the following code : I want to save the file after running this DPAnalysis.exe on jan.xls into my file system. The .exe file is running properly by taking jan.xls but not saving it anywhere . Please help Runtime.getRuntime().exec ("C:\\Program Files\\DP\\DPAnalysis.exe "+"E:\\xlsdata\\jan.xls"); Thanks in advance.

Member Avatar
Member Avatar
+0 forum 2

Hi All, I am creating an application in JAVA EE for my company where people can upload their .xls files into the fielsystem of the server. Then an administrator can integrate all the .xls files uploaded by the people into a [B]single .xls file.[/B]I am done with the uploading part and need some help with the integrating part.

Member Avatar
Member Avatar
-2 forum 2

I have an XLS file. Let's assume that it has 1000 rows in all, with 10 columns. I would like to import rows 5 through 995 (say), and columns 1 though 7 and 10. How can I do this using an SQL query, either though OPENROWSET or BULK INSERT? I am using SQL Server 2008.

Member Avatar
Member Avatar
+0 forum 1

Hello, I recently started writing a small program for reading multiple xls files from one directory. While reading one file like this,works perfectly: [CODE]wb = xlrd.open_workbook("C:\\path\\FileName.xls") sh = wb.sheet_by_index(0)[/CODE] this one doesn't: [CODE]os.chdir("C:\\path") for fileName in os.listdir("."): wb = xlrd.open_workbook(fileName) sh = wb.sheet_by_index(0)[/CODE] I keep getting the same error: [COLOR="Red"]XLRDError: Expected BOF record; found 0x614d[/COLOR] I have no idea what I am doing wrong, please help.

Member Avatar
Member Avatar
+0 forum 2

Hi im desperately in need of some help here.. Im exporting my html page data to csv but i am unable to get the data onto a new column the code is as follows [B][COLOR="Red"]HTML FORM[/COLOR][/B] [CODE]<form id="form1" name="form1" method="post" action="index.php"> <table class="formatTblClass"> <tr> <th colspan="6"><?=$message;?></th> </tr> <tr> <td width="68"><span>First Name</span></td> <td width="215"><input class="Name" type="text" name="fn" id="fn" /></td> <td width="62"><span>Last Name</span></td> <td colspan="3"><input class="Name" name="ln" type="text" id="ln" size="50" /></td> </tr> <tr> <td colspan="6"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="71">Address</td> <td width="721"><input class="Address" name="address" type="text" id="address" size="100" /></td> </tr> </table></td> </tr> <tr> <td><span>City</span></td> <td><input class="City" type="text" name="city" id="city" /></td> <td><span>State</span></td> …

Member Avatar
Member Avatar
+0 forum 3

The End.