Questions tagged as 'excel'

Tagged questions
1
answer

Error when pasting data in Excel with VBS

I have a simple spreadsheet in Excel (3 cols and 2 lines) and I'm trying to create a script to open it, copy its data and insert it into other worksheets with the same structure using a form. Private Sub UserForm_Initialize() Call AddWorkB...
asked by 01.12.2018 / 12:17
0
answers

Excel - create a top 10 with all the records

I have a site where it generates statistics in .txt, this txt after and generated in excel with all results. My goal is to create a top of the most viewed articles. This is an example: Notepad has: ID | Nome art...
asked by 09.12.2018 / 22:29
1
answer

VBA - How to identify last active line, when has formula

The code below identifies the last active row of the worksheet. When column A is populated manually it works. But when I put a formula to fill that column according to another worksheet. The code does not stop. For example: the spreadsheet h...
asked by 05.12.2018 / 14:53
0
answers

Data Flow Task Generates Blank Excel File - SQL Server Integration Services

I have a process in SSIS that takes information from a table and exports to an xlsx file. It happens that when running the Job through SQL Server Agent, the file is often generated in white, even though it has content in the table (this is not a...
asked by 11.12.2018 / 14:43
0
answers

Problem with accent character when making a GET request for google app script

Hello, is everything good? I'm doing an HTTP REquest GET for Google App Script strUrl = "https://script.google.com/macros/s/ID/exec" strUrl = strUrl & "?admissao=" & admissao strUrl = strUrl & "&cidade=" & cidade str...
asked by 29.11.2018 / 15:00
0
answers

problems with PIC + SD + Excel

I'm having some problems here, what's happening is the following, I have a project that I need to simulate a school call on the PIC and make it save in Excel, the project requires that I can change the students' entrance and exit times , and als...
asked by 25.11.2018 / 05:30
0
answers

xls created through C #, but does not add values

I have a method that generates excel (.xls), but I have a problem: excel is being generated perfectly, but when I try to sum the values of the cells nothing happens, it only adds if I open cell by cell (I do not need change any value). In the...
asked by 23.11.2018 / 15:38
0
answers

VBA - Generate a PDF file of various Excel

I'm trying to make a code to generate a PDF for every Excel file I have in a folder. First of all my code generates a PDF each excel file and then generates a PDF that would be the cover of all these files. The problem I am having is that it...
asked by 14.11.2018 / 16:45
0
answers

When trying to generate in Excel by PHP, Warnings and spreadsheet appear in the browser

From tutorial on youtube , I'm trying to generate an Excel from my MySQL DB through of a PHP query. However, the spreadsheet is not downloaded and the result generates 5 header warnings with the worksheet printed on the screen. When searchin...
asked by 19.11.2018 / 03:15
0
answers

C # - Reading Excel

I was able to read an excel file, but when displaying console the information does not get any spaces, how can I make room in the middle? kkkk usingSystem;usingSystem.Collections.Generic;usingSystem.Linq;usingSystem.Text;usingSystem.Threadin...
asked by 06.11.2018 / 17:16