Questions tagged as 'excel'

Tagged questions
2
answers

Catch only last month using R

I need to extract the last monthly values from column 2 of dataframe ntnb45 . Is there any direct way to do this in R? library(GetTDData) ntnb <- download.TD.data('NTN-B') ntnb45 <- read.TD.files(dl.folder = 'TD Files',maturity = '...
asked by 24.03.2017 / 21:20
1
answer

Find column and position the cursor in it

I have a spreadsheet that contains: COLUNA A1 CABECALHO (PRODUTOS) COLUNAS B1 A BK1 COM DATAS I will read a database ordered by product and date and I have     which automatically fill in the worksheet by allocating the values of each produ...
asked by 21.10.2016 / 20:20
3
answers

Block cell filled with VBA

We are setting up a routine where when filling a cell (C1, for example), the date (A1) and time (B1) in the worksheet are automatically filled in. But soon after the autocompletion is done I need the 2 cells to be blocked. I tested the code belo...
asked by 01.06.2017 / 15:55
4
answers

How to generate a worksheet from another using VBA

I have the following spreadsheet with the following columns: Iwouldliketogenerateasecondspreadsheetbasedontheaboveinformation,subjecttothefollowingconditions:a)Ifcategoria=='Multimídia>Multilaser',categoria='1'b)Ifcategoria=='Sestini>M...
asked by 11.03.2017 / 19:30
1
answer

VBA / Excel - Subroutines stop while I'm typing

I'm working on a spreadsheet where the user has to type a given text into a cell at a certain time. I want to put a side countdown timer so it goes by checking how much time is still missing. However, when I start typing in the cell, the stopwat...
asked by 23.08.2015 / 00:25
1
answer

Import Excel to Sql Server C #

I need to import a excel file into a SQL table. However, I need to pick up the lines and go through them, since it will not be all the information I will get from excel. I have exactly what I need but get TXT file, but the informat...
asked by 05.04.2016 / 21:26
2
answers

How to remove semicolon characters with excel

I'm trying to use an excel formula to remove the semicolon, but even with the correct formula line I can not solve it. What I have now is this: =SUBSTITUIR(SUBSTITUIR(K2;".";"");",00";"") I'm trying to replace values that are like this:...
asked by 03.04.2017 / 16:13
3
answers

Error in formula with OU

Any reason why this does not work? I want it to tell you how many situations exist within one or the other criteria. Both this formula: =CONTAR.SE.S(E:E;">120";E:E;"<139" OU F:F;">80";F:F;"<89") Like this: =CONTAR.SE.S((...
asked by 27.05.2015 / 13:22
1
answer

Error importing CSV to phpMyAdmin

I need to import a .csv file into phpMyAdmin, but the special characters do not appear, nor the text that follows them. What could be the problem?     
asked by 16.05.2014 / 20:42
1
answer

Save excel automatically generated in ASP MVC application

I am generating Excel files in my application using EPPlus . There is now a need to automatically save these files to a folder, regardless of whether or not you download them, so that you can keep track of these files. In my code I have: p...
asked by 24.04.2014 / 11:15