Questions tagged as 'excel'

Tagged questions
0
answers

Modify Excel in Python

I'm working with an xlsx that has this data: I need to make a division between cells D and C in this way: D / C and that each value is placed in the cells of column E: In this way, I only need Excel to filter the values of the...
asked by 31.10.2017 / 19:38
0
answers

How to use NPOI SXSSFWorkbook to export large xlsx

I have to export to a client in Excel 2007 (xlsx) a BBDD table of 500,000+ records through web access. Using NPOI or Epplus everything works fine until the table is very large and an Out of Memory is obtained. (ASP.NET-C # -VS2015)...
asked by 30.10.2017 / 14:32
0
answers

error in excel data from a csv with epplus

I have a csv file that has as one of its data 829/10/17 and using epplus to convert to excel it changes to this data -390883 although I force the column to type text, and probe also in perzonalidad and general and keep doing it, could you help m...
asked by 31.10.2017 / 06:38
0
answers

look for exact number in columns according to number of the left part

I have this macro Sub busca_numeros() Rem busca numeros iniciando en la celda a1 Dim unicos As New Collection Set sorteo = Range("a2").CurrentRegion With sorteo For i = 1 To .Columns.Count numero = Val(.Cells(1, i)) On Err...
asked by 29.10.2017 / 14:25
1
answer

Import EXCEL file (xlsl) to Table

What I need is to be able to load the data of an Excel sheet to a table. I already tried with bcp. Also with Bulk Insert and finally enabled: sp_configure 'show advanced options', 1; RECONFIGURE; GO sp_configure 'Ad Hoc Distributed Queries'...
asked by 17.10.2017 / 18:19
1
answer

Process data from a flat file

I am doing an activity that consists of the following: I have a list of data in plain text as follows: and I want to compare the data after the second comma, if the data is a number I have to move it after the third comma, and if the data...
asked by 17.10.2017 / 02:12
1
answer

How to perform SI.ND (VLOOKUP () ...) in PHPExcel

Good I would like to know if it is possible to make this formula in PHPExcel =SI.ND(BUSCARV(A46;Dat_STATUS_EXP;2;FALSO);0)+Q46 I have noticed that the function SI.ND could not use it, since it does not exist for excel 2007. I have...
asked by 29.09.2017 / 15:25
0
answers

Access error with Microsoft.Office.Interop

Good morning, I have an application in which I generate an Excel from some html files, everything works correctly locally but when I publish it on the server it works sometimes if and sometimes not. I am not able to come up with the solutio...
asked by 12.09.2017 / 11:13
1
answer

UTF8-Excel PHP report

I have the problem that I do not recognize the special characters, I tried the following but it is not displayed correctly: My header header("Content-Type: text/html;charset=utf-8"); Column in which I want you to show me signs, strange c...
asked by 28.09.2017 / 22:06
1
answer

Problem with CakePHP Excel

As the title says I am trying to implement CakePHP Excel, and with the 3 plugins tested so far: Cewi Excel dakota / CakeExcel maraya / CakePHPExcel After installing them with Composer, and making all the configuration, when inserting...
asked by 08.09.2017 / 21:30