Questions tagged as 'excel'

3
answers

Graph data already read from .xls files in html5

This button must be programmed to read a file in Excel with two columns, the first with data (x) and the second with data (y). the new records must be graphed but I have not yet achieved it. var lineChartData = { "datasets": [{ "data": [...
asked by 05.10.2016 / 23:21
1
answer

date format to string in java with apache from excel

I have to read the format of a cell with date to String, it works fine but the year is strange, I attach part of the code and what it shows: case Cell.CELL_TYPE_NUMERIC: SimpleDateFormat sdf = new SimpleDateFormat("dd/MM/yy...
asked by 28.09.2016 / 04:54
3
answers

Heap java administration

I'm doing a copy paste, from excel to JTable . The problem is that it consumes too much memory. I have looked for solutions to do that procedure in other ways but I can not find it. If anyone knows another way to do it, I appreciate it bec...
asked by 03.10.2016 / 17:24
3
answers

Define separate cells instead of a range in Excel formula

Suppose I have the following table: |-----|-----|-----|-----|-----|-----| | A | B | C | D | E | F | |-----|-----|-----|-----|-----|-----| 1 | s | n | n | s | s | s | |-----|-----|-----|-----|-----|-----| 2...
asked by 02.03.2017 / 16:55
1
answer

Problem when opening an excel book through VBA

I have an Excel with a UserForm , from which using a CommandButton I open another Excel file by: Workbooks.Open Filename:= "XXXX.xlsx" The book opens it to me well, but I can not edit it and the most serious thing, I can not ev...
asked by 06.10.2016 / 11:35
1
answer

Number saved as text in excel

I have an automatism that takes data from different data sources, the problem is that there are some decimal data that I save as text. How can I do so that I do not save these numbers as text? This is what I have now //Variables interop...
asked by 12.04.2018 / 10:09
1
answer

Collect answer .bat from VBA

Des of VBA I execute a bat using Call Shell (...) and it works correctly. Now I need to pick up the answer of this bat, which has an "Echo answer". Any ideas on how to do this? Thank you,     
asked by 10.08.2018 / 10:26
3
answers

How to generate a parameter of dates in excel?

I have a parameter of dates accommodated by levels, taking into account today's date, 30 dias antes de hoy = fase1, 45 dias antes de hoy =fase 2, 60 dias antes de hoy=fase 3, 90 dias antes de hoy = fase 4 y mas de 90 dias apartir de hoy=fa...
asked by 08.02.2017 / 23:40
1
answer

copy data from a csv to an excel using vba

I want to copy data that I have in a csv to an excel using vba. I have the code that does it, but I do not want to copy the first row of the csv and I do not know how to do it. This is my csv: And this is my vba code of an excel: Priv...
asked by 24.04.2017 / 10:25
1
answer

Export JTable with header to Excel

I would like to know how I can do so that when exporting a table to Excel from Java , I can include a header such as my company name or something like that. I can export the table without problems, but I do not know how to put a header, or at...
asked by 30.12.2016 / 02:58