Stack Overflow
Stack Overflow

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

Is there some kind of option to merge Excel files by column IDs?

What I mean is, if I have: f1.xls Product ID / Product Name 1 / 12 2 / 13,64 f2.xls Name_ID / Name_Val 12 / aaa 13 / bbb 64 / ccc Can I somehow merge them to: Product ID / Product Name 1 …
Slava Zoref
  • 305
  • 2
  • 5
  • 16
0
votes
1 answer

Download xls file angular jax-rs

I use jax-ws in the server side and angularjs in the client side. I'm trying to download an xls file send from server side. In the server side i use this code: @GET @Path("/exportemployeexls") @Produces("application/vnd.ms-excel") …
Yahia Ammar
  • 280
  • 4
  • 20
0
votes
1 answer

Java Null Pointer Exception for Apache POI in reading cell data for CSV conversion

I'm trying to do two things for this application:one when the class is called upon, it will run from top to bottom and two, I can call the public method "xlxTOcsvConverter" and supply the three needed parameters for future use...that said, if the…
user3377627
  • 363
  • 3
  • 7
  • 22
0
votes
1 answer

In Java,using Apache POI, how can I pull cell data as is, not the formula?

Some cells have data concatenated from other cells. In trying to write a csv file from the parent file, some cells are written to the csv file by their formula not, the value of said formula. I need the resulting value, not the formula itself.
user3377627
  • 363
  • 3
  • 7
  • 22
0
votes
1 answer

Can't compile NPOI project

I'd like to use the NPOI dll in my project, so I downloaded the source code from [https://github.com/tonyqus/npoi] as there was no binary download. I opened this solution \solution\visualstudio\NPOI.sln and compiled it, However I get the following…
hyperkittie
  • 641
  • 6
  • 16
0
votes
1 answer

Export Excel 97-2003 (xls) with template (VBA macros and format, style) without COM

I have an Excel template 97-2003 (xls) which contains some VBA macros, format/formula and style and I put it on my web application (ASP.Net MVC, c#) and I'm stuck in writing function 'export data filled in this Excel template without using COM,…
khangcv
  • 81
  • 2
  • 8
0
votes
1 answer

VBA Code to Convert CSV to XLS

Objective: I have a folder where multiple CSVs are dumped on my drive. These CSVs need to be converted to XLS files and saved (as XLS files) into the same, original folder. I have a code (pasted below) for it that works just fine, but... Problem: A…
Chase
  • 544
  • 1
  • 11
  • 25
0
votes
1 answer

How to change color of a cell of an existing excel (xlsx or xls) in java

I have requirement in that i have to read and validate the excel file and insert to data base, initially i am reading the file and inserting it to database, if the data already there in database, i am returning row and column numbers of the…
SivaTeja
  • 378
  • 1
  • 3
  • 16
0
votes
1 answer

How can I only group on PDF output (and not Excel output) in BIRT report?

In reports that use Table Groups and rows with aggregations based on those groups, I set each group row to Hide Element for xls file output. However, that just hides the aggregate values, and the data is still being grouped. How can I make it so…
Orin
  • 419
  • 1
  • 5
  • 10
0
votes
1 answer

How to export data to an excel file w/chart on iPhone?

I have some data in a sqlite database in my app, and my client wants an option that allows you to email it as an excel file which includes a chart of the data. Is this possible on an iPhone? Have a good one, Toby
Toby
  • 390
  • 4
  • 18
0
votes
0 answers

Determine the number of days a bill range falls into two different date ranges

I am trying to calculate how many days a utility bill falls within two categories (date ranges).i.e. a bill range may be between 16/8/14 - 14/10/14 (total of 60 days incl) and I want to work out how many days fall in the 1/10/2014-31/3/15 season…
Ingrid
  • 1
0
votes
1 answer

How can I convert an xls doc worksheet (from a workbook) to semicolon delimited csv (or txt or anything else) using Win7 native apps

I have been using both libreoffice and excel and I can run a vbs that opens excel invisibly and does this, but my company is going to move over to libreoffice. The issue with libreoffice, which is nice enough to have a built in converter, is that it…
user3377627
  • 363
  • 3
  • 7
  • 22
0
votes
1 answer

MATLAB xlswrite name data

How can I assign a name to a matrix being written from MATLAB to Excel using xlswrite? This is equivalent to opening the xls sheet, selecting the data and right-click->define name. Here I can assign a string to the matrix. How can I do this from…
S_S
  • 1,276
  • 4
  • 24
  • 47
0
votes
1 answer

Subtract time from duration only if above specified amount

Working on a timesheet (duplicate of sheet 1 in link). The current function to handle the calculations is: B4=6:00am C4=6:00pm X4=0:30:00 =IF(OR(B4="",C4=""),"",IFERROR(C4-B4-X4,"")) The thing is we don't subtract 30 minutes for lunch unless an…
tek0011
  • 147
  • 1
  • 4
  • 12
0
votes
1 answer

sum a column in a sharepoint 2007 list and pass the resault to another list

I am very new in share point. I have 2 lists, projects and tasks as follow: Projects List ------------------------------------- project title | %Complete | PJ 01 0% PJ 02 0% Tasks…
Ali Akhtarkhavary
  • 1
1 2 3
…
99 100