Questions tagged as 'excel'

Tagged questions
1
answer

How to upload CSV file to SQL Server with SSIS

Hello dear, I hope you can help me. I am developing a workflow in SSIS to load Excel 2010 files into a table in SQL Server 2008-R2, many of the fields in Excel have text of more than 255 characters and are sometimes truncated in that value,...
asked by 07.11.2018 / 00:32
1
answer

The value of the specified String type of the data source can not be converted to the nvarchar type of the specified target column SqlBulkCopy

My problem is the following I am wanting to pass an excel file to sql server. When I take the file and I want to pass it, I throw this error:    "The value of the specified String type of the data source can not be   convert to the nvarchar t...
asked by 24.10.2018 / 18:20
1
answer

execute code in all 3 sheets in excel

Good morning experts How can I add this code so that it executes at the same time on the 3 sheets when I make each number change in cell A1 Sub Controldenúmero1_Cambiar() Dim n As Integer For n = 1 To Len([A1]) BuscarÁrea n, Mid([A...
asked by 03.10.2018 / 00:17
3
answers

VBA reading a JSON

I'm trying to read a Json that returns a web service and show the data in an Excel using VBA. I call her with this: Dim hReq As Object Dim strUrl As String strUrl = "http://api.worldweatheronline.com/premium/v1/weather.ashx?key=db3927718fd...
asked by 21.09.2018 / 12:13
1
answer

Open an Excel file from an ASP.NET form

Hello friends, I'm getting an excel like HttpRequestPostedFileBase from a form of Asp.NET , but I need to open it, I know I can store the file and send it to me    Workbook sheet = excel.Workbooks.Open ("path / file.xls"); The path o...
asked by 16.08.2018 / 17:58
2
answers

Insert an Excel file in PostgreSql

I am looking for information on how to insert an Excel file in PostgreSql, but I can not find information, there is no guide or tutorial from scratch, all are concrete problems on the internet. My intention is for the client (Angular2) to sen...
asked by 12.07.2018 / 11:48
1
answer

Download BD in several Excel

is that I have a site that downloads the bd in an excel file but the thing is that I arrive at so much data that the excel file arrives damaged, so it occurred to me that I could only upload, say, a thousand data and that when the thousand thous...
asked by 31.07.2018 / 00:01
1
answer

Does anyone know how to read an excel with PhpSpreadsheet in Codeigniter?

I am trying to read an excel file in codeigniter to save it in a database. I was looking for a php library to work with excel and found phpExcel but when I go to the site it tells me that it is deprecated and that it is now phpspreadsheet...
asked by 05.01.2018 / 15:38
1
answer

Excel Application Formula in Cell

with visual foxpro I do an excel and in two of the cells I apply two formulas. The first one comes out OK, but the second one appears in Excel with # Name? 1 formula: oSheet.Cells (nFila, nCol) .Formula="= H" + as (nFila) + "* C" + as (nFila)...
asked by 24.06.2018 / 09:27
1
answer

macro, join sheets of different books of excel

I am a macro researcher in excel, so far I consider myself a beginner in this work, I need your help to solve a problem. I need to merge several excel files into one, this I have been able to achieve with a macro like: Sub simpleXlsMerger()...
asked by 04.06.2018 / 19:53