Questions tagged as 'excel'

Tagged questions
1
answer

Change Target of a File Shortcut with VBA

I'm changing the name of several worksheets at the same time, but some of them have shortcuts, and in the middle of the change I want the shortcuts to accompany that change. Sub changeTargetPath() Set wsc = WScript.CreateObject("WScript.S...
asked by 17.05.2017 / 16:53
1
answer

Format Excel output - Python

I transform a list into a Dataframe and send it to an Excel, it's working fine. Here is the code: Df = pd.DataFrame(Lista, columns = colunas_geradas) writer = pd.ExcelWriter('Exemplo.xlsx', engine = 'xlsxwriter') Df.to_excel(writer, sheet_nam...
asked by 17.05.2017 / 16:55
1
answer

Excel - Tables - Identifying the next line

Good afternoon. This is my first question here. Right now, I thank anyone who can guide me. I made a spreadsheet with some tables (tab "Home", "Format as table"). Then I made a VBA to clear this table and insert new information from a text fi...
asked by 28.04.2017 / 21:59
1
answer

Problems reading all the rows of an Excel with OLEDB and C #

I am developing a program to import Excel spreadsheets with language C# , using the OLEDB component, when importing a spreadsheet with 100547 rows the program can only read 54046. Here is the source code: public class Re...
asked by 29.03.2017 / 19:16
0
answers

How to convert a string from a worksheet to date format for mysql?

I'm looking for a way to do this, but I'm not sure how to do it. try converting to mysql but in the insert the following column error appears    'column name' can not be null follow the insert $salesplan_insert = mysqli_query($link,"i...
asked by 15.03.2017 / 13:10
0
answers

(Spreadsheets / Google Docs) Autocomplete if cell is filled [closed]

Basically, what I liked to do was: Whenever person 1 (eg example) added a date in the table on the left side, the calendar on the right was automatically filled in. with the person's day and color. Home Is it necessary to make a script?   ...
asked by 08.03.2017 / 00:56
0
answers

Normalize database (unpivot columns per month)

Good evening, An Excel table with PERVASIVE SQL binding with one column per month, that is, 12 columns. In order to better work the data, I need to turn the 12 columns into only 2:  - a 1st with the values that were in the 12 columns  - a sec...
asked by 28.03.2017 / 22:29
0
answers

Rotation parameter in Jasper or iReport does not work when exporting to ODS format

Hello My code: <staticText> <reportElement mode="Opaque" x="282" y="0" width="59" height="82" backcolor="#C4C4C4" uuid="8c5029ee-1b1d-41e8-a82f-ef2f879009c0"/> <box> <topPen lineWidth="1.0"/> <leftPen line...
asked by 17.02.2017 / 15:24
2
answers

EXCEL - ELEGANT FORMULAS

Hello, I need help to create a more elegant formula than the one below: =IF(OR(AND(C11>=3302000;C11<=3303999);AND(C11>=3602000;C11<=3603999)); $B$3;IF(OR(AND(C11>=3402000;C11<=3403999);AND(C11>=3702000;C11<=3703999)); $...
asked by 31.01.2017 / 16:40
1
answer

Using Access to Export in Excel, Parameterized Query

I'm using the Access database, I need to export a query to excel. My problem is as follows: I am using a parameterized query in Access for the access itself to export to excel. When I make the call to export, it opens the screen to ente...
asked by 08.12.2016 / 19:52