Questions tagged as 'excel'

Tagged questions
0
answers

Collect excel data to make a web login - JS -

Good evening! I want to write a Javascript code that does the following process: Open the Excel file attached to the Robot folder, access the web with the contents of the ADDRESS cell, inform the User and Password with the contents of the...
asked by 18.02.2018 / 00:18
0
answers

CodeBlock with MingW to create .xll file

Good evening I'm new here and I scratch some C / C ++ prog that I had in college and I'm trying to use it at work, more precisely in Excel ... As VBA sucks, I need to create some functions in C / C ++ and generate an excel addin. I'm fo...
asked by 16.02.2018 / 06:17
0
answers

Write an XML using C # XMLwriter from an Excel table

Hello, I've never used the XMLwriter before, this is something totally new to me. I have a table in excel and I need to create an XML file from it, the first column will be the main node, and every other column a sub-node (I'm sorry for the term...
asked by 16.01.2018 / 23:57
0
answers

How to merge two tables with repeated primary keys?

I have two tables that we need to unify in one, in a complete way: Consider everything in the first, see if it hits the second and what does not beat or repeat, include in the end lines. Note that key 2 is replayed in the second table, so a p...
asked by 11.01.2018 / 12:04
1
answer

VBA Error Viewing Data from a Worksheet

I'm experimenting with VBA and I've been able to add data to a DB on Sheet 2 . And now I've tried to show the data on sheet 1 where I choose the ID and it shows the data inserted there, but it gives me an error. Sub Busca() Dim valor A...
asked by 20.12.2017 / 15:11
1
answer

Export html table to excel using javascript by removing a specific column

I have the following script to perform an export of a table to excel: <script> function fnExcelReport(){ var tab_text="<table border='2px'><tr bgcolor='#87AFC6'>"; var text...
asked by 15.12.2017 / 14:24
3
answers

Count values from one column based on a filter from another column

I have a spreadsheet where I have some data. Of these data, I need to count the values that are repeated from a column SE the cell value of the same row, but from another column, is equal to a given value. I made the following formula:...
asked by 11.12.2017 / 20:42
0
answers

How to use the chunk method of Laravel Excel?

public function uploadNotaCorte(Request $request, EstadoRepository $estadoRepository) { $error = array(); $path = $request->file('file')->getRealPath(); $notasCorte = Excel::load($path, function($reader) { })->...
asked by 22.12.2017 / 21:52
0
answers

Error opening excel generated in php warning that it is corrupted

I have a system that generates forms for the client, and when it fills in this automatically saves an Excel with the data, but when I go to open Excel appears the error: O formato de arquivo e a extensão de 'Nome do arquivo'.xls' não correspon...
asked by 22.12.2017 / 16:26
0
answers

Get data from excel sheet and insert into SQL SERVER database

I want to know if you have a way to get the records of a worksheet and play to a SQL-SERVER table, is there a possibility?     
asked by 08.12.2017 / 13:23