Questions tagged [xls]

xls is the file extension for files created using the default format of Microsoft Excel (prior to Excel 2007).

xls is the file extension for files created using the default format of Microsoft Excel (prior to Excel 2007). An Excel file uses the BIFF (Binary Interchange File Format) format. Documentation for the format has been made publicly available by Microsoft, and can be found on MSDN

1871 questions
0
votes
1 answer

Issues in converting CSV file in to XLS

Hi all I want to convert a CSV file in to .xlsx file I write the .xls file like below. InputStream in = new FileInputStream("csvpath"); OutputStream out = new FileOutputStream("xlsPath"); byte[] buf = new byte[1024]; …
user3906011
0
votes
1 answer

Download File from http handler with custom name

I have different files in upload folder with .doc, .docx, .pdf, .xls etc and i want to download file when click on image. I am calling http generic handler from jquery values are pass correctly but not working …
0
votes
1 answer

ASP Classic Text Driver For Windows 2012

We have an old ASP Classic website which has been running on Windows 2003 and needs to be moved to 2012. Most of the site works apart from a section where we need to be able to upload CSV or Excel documents full of categories to the server. I know…
MonkeyMagix
  • 677
  • 2
  • 10
  • 30
0
votes
1 answer

Perl script to convert xls to csv

This script coverts xls to csv ok. The challenge is that it does not convert blank cell in the xls to blanks in csv file. Any help is appreciated: UPDATED SCRIPT #!/usr/bin/perl use strict; use Spreadsheet::ParseExcel; use Text::CSV; my…
Drsin
  • 43
  • 7
0
votes
1 answer

How to edit existing .xls Excel file using PHP

I am trying to edit my existing .xls Excel file. But i can't find the proper way to edit existing .xls excel file. I had used PHPEXCEL for reading the .xls file and then writing the .xls file. But in that I lost some excel functionality like…
0
votes
1 answer

R can't manage "General" formatted cells when reading libreoffice generated xls

I switched to libreoffice for my spreadsheets, but I noticed an error when importing an xls file modified with libreoffice inside R using the gdata package's read.xls() function. If a column is formatted as General, then once in R the cells display…
Bakaburg
  • 3,165
  • 4
  • 32
  • 64
0
votes
1 answer

PHPExcel wrongly reading xls file as HTML

I am using PHPExcel to read a large "xls" file. Firstly, I am determining the file type for reader using PHPExcel_IOFactory::identify($inputFileName). However, PHPExcel is wrongly identifying it as HTML file and using HTML Reader which fails with…
AJINKYA
  • 741
  • 2
  • 9
  • 20
0
votes
1 answer

How to read password protected .xls file in java?

I have a code which reads a protected excel in java, but that code gives me error. My java code. import java.io.FileInputStream; import java.io.FileNotFoundException; import java.io.IOException; import java.security.GeneralSecurityException; import…
vijayk
  • 2,633
  • 14
  • 38
  • 59
0
votes
1 answer

How to convert a xlsx file to doc table format using php

I would like to convert a xlsx file into doc table format. How can I do that ? Is there any api for handling doc files using php ?
Mijoe
  • 236
  • 2
  • 9
0
votes
1 answer

How to create a standard spreadsheet file programmatically without using LibXL?

I want to create standard spreadsheet files in objective-C which can be opened in ipad too, without using paid libraries such as LibXL. I already created HTML tables and simply created a .xls file by using following code( string1 contains HTML…
Rohit_RK
  • 405
  • 4
  • 12
0
votes
1 answer

Xcode Create xls file, but failed to open on IPAD

I have created xls file using this library, https://github.com/andreac/RSSheet/tree/a3a1c3f9802e67508a773399007ffb9ebf8135c6 But I only can open the created xls file on PC or MAC and I cannot open it on IPAD using any software. My client want to…
Nijat2018
  • 863
  • 2
  • 10
  • 26
0
votes
1 answer

jXLS evaluate inner variable

I tried to evaluate an inner variable like ${messages.${column}} in my first jXLS template without any success. Could someone help It is even possible? Any help would be appreciated. Cheers Joska
0
votes
1 answer

Create xls file gibrish

I am trying to return xls file in hebrew but it returns me gibrish letters and writes that the file extension isn't the file real content. Please help me. public void ExportAddBalanceExcel(int CompanyID) { string writer = ""; writer +=…
Limor
  • 1
  • 1
  • 3
0
votes
1 answer

How to fix date format when converting a text file into excel?

I use amacro to convert txt files into xls but I have the problem that the fields with dates are not converting in the right format. For example I have the date 4/11/2014 (dd/mm/yyyy) and when the file is converted into xls, I have the date shown…
1 2 3
99
100