xls Questions
6
Solved
I am reading integers from a text file, giving them as input to a query and getting the query output and writing to an xls file.
ResultSet rs;
Connection con = null;
PreparedStatement ps = null;
i...
14
Solved
I need to fill a cell with the first non-empty entry in a set of columns (from left to right) in the same row - similar to coalesce() in SQL.
In the following example sheet
---------------------...
4
Solved
10
I am trying to convert a .xls file to an .xlsx file on the server-side using Microsoft.Office.Interop.Excel.Workbook class as follows:
workBook.SaveAs("FILENAME_HERE", XlFileFormat.xlOpenXMLWorkb...
Yellowgreen asked 27/2, 2014 at 7:52
3
Solved
My current CI project is now handling files. I want to upload the xls| xlsx files to the server and then import Excel data into the Database table.
As the first part, the uploaded file was successf...
Bolivar asked 31/12, 2014 at 7:52
2
Solved
I can change foreground color with the following code in apache POI. Now I want to change font color of a single cell.
CellStyle style = wb.createCellStyle();
style.setFillForegroundColor(IndexedCo...
Firth asked 31/3, 2013 at 13:58
17
Solved
I am able to read Excel file via FileReader but it outputs text as well as weird characters with it. I need to read xls file row-wise, read data in every column and convert it to JSON.
How to rea...
Vacuous asked 23/11, 2011 at 7:8
6
Solved
I have to port an algorithm from an Excel sheet to python code but I have to reverse engineer the algorithm from the Excel file.
The Excel sheet is quite complicated, it contains many cells in whi...
5
Solved
Does anyone know how can I convert JSON to XLS in Python?
I know that it is possible to create xls files using the package xlwt in Python.
What if I want to convert a JSON data file to XLS file dir...
22
Solved
We have a lot of spreadsheets (xls) in our source code repository. These are usually edited with gnumeric or openoffice.org, and are mostly used to populate databases for unit testing with dbUnit. ...
Gerge asked 22/9, 2008 at 12:54
16
Please can someone help me on the best way to import an excel 2007 (.xlsx) file into R. I have tried several methods and none seems to work. I have upgraded to 2.13.1, windows XP, xlsx 0.3.0, I don...
5
Solved
6
I am trying to read a excel file.
import requests
url = 'http://www.nepalstock.com/todaysprice/export'
r = requests.get(url, allow_redirects=True)
open('todayprice.xls', 'wb').write(r.content)
imp...
5
I am trying to read just one sheet from an xls document and I have this:
$objPHPExcel = $objReader->load('daily/' . $fisierInbound);
$objWorksheet = $objPHPExcel->setActiveSheetIndex(0);
fore...
4
Solved
We are in the transition at work from python 2.7 to python 3.5. It's a company wide change and most of our current scripts were written in 2.7 and no additional libraries. I've taken advantage of t...
Yardley asked 7/2, 2017 at 14:23
3
I'm trying to convert a .xls file to .pdf using LibreOffice via command line on Ubuntu. I have a kind of report on the .xls file with some colors in the background of the cells and etc.
The proble...
Thematic asked 16/9, 2014 at 21:49
2
Solved
A friend of mine doing an internship asked me 2 hours ago if I could help him avoid to do manually 462 pdf file to .xls using free online soft.
I thought of a shell script using unoconv, but I did...
Organ asked 12/12, 2012 at 16:12
5
Solved
I have a question about exporting an HTML table as an xlsx file. I did some work and now I can export it as an xls, but I need to export it as an xlsx.
Here is my jsFiddle: https://jsfiddle.net/27...
Catamenia asked 28/5, 2016 at 12:0
8
I have multiple .xls (~100MB) files from which I would like to load multiple sheets (from each) into R as a dataframe. I have tried various functions, such as xlsx::xlsx2 and XLConnect::readWorkshe...
13
I am using win32.client in python for converting my .xlsx and .xls file into a .csv. When I execute this code it's giving an error. My code is:
def convertXLS2CSV(aFile):
'''converts a MS Excel f...
Derryberry asked 27/3, 2012 at 6:25
4
Solved
I have a requirements to read XLS files (not xlsx) using PhpSpreadsheet and I having trouble. I tried this (as the documentation say but...)
require 'vendor/autoload.php';
use PhpOffice\PhpSpreads...
Daunt asked 13/9, 2018 at 16:52
11
Solved
I have a small problem that I can't seem to figure out. I am saving a DataGridView (it's contents) to an xls file. I have no problem in doing so except in my task manager its still showing up that ...
7
Solved
Question 1: How can I check if an entire .xls or .csv file is empty.This is the code I am using:
try:
if os.stat(fullpath).st_size > 0:
readfile(fullpath)
else:
print "empty file"
except OS...
Sybille asked 1/3, 2017 at 16:37
5
Solved
I'm currently learning C#, and recently I've learned about the MVVM design pattern for WPF. I am writing a simple program as a way to practice this, but I'm not sure where I should write the method...
4
Solved
I am developing a simple Java program to create an Excel file using (Apache POI) API.
I am using Oracle 10g as a database and using the ojdbc14 JAR file.
I have a table called USERINFO, having thr...
Gielgud asked 11/1, 2012 at 9:56
1 Next >
© 2022 - 2024 — McMap. All rights reserved.