Questions tagged as 'excel'

Tagged questions
1
answer

Java - Import Excel with combo and checkbox

I need to perform an excel spreadsheet import using java. Only the worksheet has selection values such as checkboxes and combos. As in the example below: Does anyone have an example java code that can retrieve these values, with Apache...
asked by 30.10.2017 / 20:46
1
answer

Write dates (month / year) between two dates

Hello, I have two dates: Initial Before Jan-11 Oct-10 Feb-11 Sep-10 I'd like to know how I can have a macro that writes the date between them by adding these dates to two new rows and look in the price table for the price f...
asked by 30.10.2017 / 18:34
0
answers

Excel is crashing when I use xlwings [closed]

I'm using python with excel through the xlwings package. The problem is that excel stops working whenever I try to import a function into the xlwings tab. I have already restarted the pc, but the problem still continues.     
asked by 25.10.2017 / 15:10
0
answers

Can I create columns with formula? Excel

Good afternoon. I want to know if it is possible to create a column with function / formula (when we use the = symbol)? In the same way that we use in many functions, type = SE, = CONT.SE, = PROCV ... If it is possible, how can I do this? Bec...
asked by 09.10.2017 / 21:22
0
answers

VBA - Copy and paste data without column sequence to rows

Hello! I have a spreadsheet with two tabs: In PLAN1 I have a single column with several data, but they do not follow a sequence. The values that can be found in this column are: Product code (Ex: AAA7X), A xxxx, B xxxx, C xxxx, D xxxx, E xxxx, F...
asked by 11.09.2017 / 21:13
1
answer

Compare two columns in EXCEL and if they are equal return a certain value

I'm having trouble generating a logical structure (If) to validate some data. It's for a search. follows the explanation: There are two columns ( B and H ). In the B column there are all Brazilian municipalities and in column H there ar...
asked by 04.09.2017 / 01:39
0
answers

capture excel formula with php

I need to capture the formula that is behind the generation of the data of an excel with php, but in all my imports I only managed to capture the value of the field, how to proceed?     
asked by 17.08.2017 / 21:08
1
answer

Export Table to Excel, Problems with String Numerica

I looked here in the Stack, but maybe I did not find the right question, I'm exporting data from PHP to Excel with HTML tags, it exports in a good, I happen to have a column that is String, for example "89551010326000103872", but I have tried to...
asked by 04.09.2017 / 19:16
0
answers

Error creating Excel file with PHPExcel

I would like to know the correct way to align the text in all columns; adjust the width of all columns; and, also apply bold in cell ranges. The way my code is, it does correctly, however, it generates the error below:    PHP Notice: Und...
asked by 11.08.2017 / 05:46
0
answers

Fill in a chart chart with excel data

I'm creating a dashboard based on an excel sheet, I was able to create the charts using chart.js but I do not know how to get the data to be taken from the worksheet, does anyone know a way to do this? (the graphics I created, typed the value of...
asked by 19.07.2017 / 14:26