Questions tagged as 'excel'

Tagged questions
2
answers

Apache POI - Error opening file generated in MS Excel

Hello, I'm running some tests with Apache POI , version 3.15 , for .xlsx reporting using the sample code below, only to generate a file: package exemplousoapachepoi; import java.io.*; import org.apache.poi.xssf.usermodel.*; /** * * @...
asked by 23.11.2016 / 17:11
1
answer

Return all values of an array with conditions

I'm trying to get a list of products from 2 values in excel. I have seen in this tutorial that I can make a formula of the following way: ={SEERRO(ÍNDICE($A$6:$B$15;MENOR(SE($A$6:$A$15=$E$5;LIN($A$6:$A$15)-5);LIN(A1));2);"")} This is the...
asked by 12.11.2016 / 02:48
1
answer

Generation of Excel in classic asp generating blank worksheet

I have a testexcel.asp file that for excel generation: <%@ Language=VBScript %> <% Response.AddHeader "Content-Disposition", "attachment; filename=excelTest.xls" Response.ContentType = "application/vnd.ms-excel" %> <table>...
asked by 26.07.2016 / 23:02
1
answer

Python - "Error: IndexError: list index out of range"

I can not find the cause of the error. The program runs fine, it displays all the rows of the table, however, this error message appears. import re import xlrd wb = xlrd.open_workbook('exemplo.xls', encoding_override="cp1252", ragged_rows=Tru...
asked by 17.07.2016 / 18:27
1
answer

How to fetch multiple values from a plan

Hello, I have a spreadsheet with lots of data, and I would like to separate them each in one worksheet by category, for example: all products that are as of September are shown in another worksheet or all product codes that are repeated are place...
asked by 13.07.2016 / 02:57
1
answer

How to generate Forms without title bar in VBA / Excel?

I need to work with some forms without the title bar in VBA / Excel. I found many similar solutions, but all for 32 bits (mostly in older versions of VBA).
asked by 22.08.2016 / 23:37
1
answer

Divide the first record of a column by the last record

I have a table that shows data reported during the period of one month: DATA REGISTRO 01/06/2016 02/06/2016 03/06/2016 04/06/2016 05/06/2016 50 06/06/2016 60 07/06/2016 10 08/06/2016 20 09/06/2016 50 10/06/2016 60 11/06/201...
asked by 29.06.2016 / 22:26
2
answers

How to find next values from the same client

If you can help me with this one, I think it will work for others as well. I'm trying to make clicking on searching the TextBoxes are populated with the client data, and again clicking the Search button the TextBoxes are loaded with the next rec...
asked by 28.06.2016 / 18:35
1
answer

Read excel information in array form with python

I'm using Python 2.7 to read values from an Excel document. When I have only one line of values with its header I can read, doing from openpyxl import Workbook from openpyxl import load_workbook wb = load_workbook("Resultados.xlsx") Nod=49 #nu...
asked by 22.07.2016 / 17:25
1
answer

How to generate excel batch files in MVC?

I need to generate separate Excel files. I tried doing a foreach foreach (var item in listExtracts) { DataTable table = Mytable; var grid = new GridView { DataSource = table }; grid.DataBind();...
asked by 05.05.2016 / 13:57