Questions tagged as 'excel'

Tagged questions
3
answers

Calculate Present Value in Javascript

I need to calculate the present value equivalent to the Excel formula, I have the following data: VP (2.5%; 48; -2052.50) that excel does not return me the value of 57,000.00 rounding down. Can anyone help with this in javascript? I tri...
asked by 30.06.2016 / 22:30
1
answer

Add seconds, minutes and / or hours in datetime field

I have a field with date and time in Excel (column F) and would like to add seconds, minutes and / or hours, but the form used, as in the example image below, adds the value in days (column G): How do I add specific seconds, minutes, a...
asked by 27.11.2018 / 11:25
1
answer

Import data from excel to sql server

I need to import the data that is in excel to a table in sql. I looked at several sites but nothing so far has worked out. Using sql server management studio I have done the following so far, following the step a step : sp_configure 'show adv...
asked by 26.08.2014 / 17:09
2
answers

PHPExcel generates broken worksheet [closed]

I'm using the PHPExcel class to export a DB table. But I'm having trouble downloading the spreadsheet. To test, insert values manually without doing any select in the DB. But when it generates the spreadsheet and downloads it, the spreadsheet op...
asked by 03.12.2015 / 19:46
1
answer

Error while trying to read excel file C #

public partial class FrmEditar : Form { private OleDbConnection _olecon; private OleDbCommand _oleCmd; private static string _arquivo = string.Empty; private string _stringConexao = string.Empty; private string _consulta;...
asked by 08.01.2017 / 21:03
3
answers

Generate Excel with query php

I need some help. I have a query in php and mysql and I would like to add to this query the option to export the data also to excel. Is it possible to do this with php? <div id="tabs"> <ul> <li><a href="#tabs-1">Inf...
asked by 26.05.2014 / 18:20
2
answers

How to expand range of numbers with data?

As I would in excel to expand a huge list with data to instead of grouping value data, it would show the content in total. Example: I would like to turn this: Inthis: Remembering it will be a huge list of values. So something autom...
asked by 14.09.2017 / 18:26
3
answers

Can you have automatic recalculation of Excel trigger a routine in VBA?

I have a graphic scheme in Excel that is done by means of conditional formatting (see figure below), that is, in colored cells there is no content, only the background colors are changed based in values from other cells. Thedashedbluelinei...
asked by 18.04.2017 / 23:20
1
answer

Select columns with no specific name

I'm developing a C # application that consumes data from a spreadsheet, and at some point I need a query string that will feed a variable. For example: strComando1 = "SELECT TOP 2 ColunaGenerica1, ColunaGenerica2 FROM ["+ planilha +"]";...
asked by 09.02.2018 / 13:21
3
answers

How to use a Command Button inserted in the Spreadsheet in VBA code?

I have a command button that I inserted into a worksheet, and I wanted to know which function I have to assign in the vba code, to know when a user clicks it!     
asked by 10.02.2016 / 19:07