Best answeres tagged with excel

3

answers

How to read a excel file in C # and save the data into strings? [duplicate]

asked by 21.10.2015 / 12:31

1

answer

Command for Fill Effect in Excel VBA

Friends, I'm using the hint, described in the "Excel Guru" script in Creating Interactive Maps in Excel: Sub ColorirMapa() Dim Microareas As Range Dim Celula As String For Each Microareas In Range (“Microareas”) Celula = Cells (Microareas....

asked by 03.11.2014 / 21:36

2

answers

Exporting data from php to xls from a link

I am making a link, which when the user clicks on it should generate an xls file. The link has the date-attributes and should pass these attributes to the page.php and generate the xls. I tried jquery and it is not working, does it have any othe...

asked by 22.07.2014 / 19:12

1

answer

How to use the Laravel Excel Library

I have a .csv where I need to import your data into the database. To do the import I'm using a Laravel library. What's in here: link In the code I'm doing this: <?php namespace App\Http\Controllers; use App\Http\Requests; us...

asked by 10.08.2015 / 22:45

2

answers

Get values from an excel sheet and display in a popup

asked by 13.11.2017 / 16:50

1

answer

Counter to insert blank line every 5 equal cells

Hello, I'm trying to make a macro for a button, which puts a blank line every 5 cells with equal content, however I'm quite lazy in the VB syntax and I'm not sure if the logic is correct either, example of what should happen: ADA ADA ADA ADA AD...

asked by 05.04.2018 / 21:16

1

answer

What are the differences between Power Query, Power Pivot, Power BI?

I want to make a contribution to the community by presenting these free tools for data analysis using Microsoft and unfortunately are little known and exploited by many and can be very useful in our widely used automation and reporting work toda...

asked by 31.01.2018 / 23:57

1

answer

Protect Excel worksheet in C #

In a C # application, it can take from 1 to 2100 hours of data gathering. The data is saved in a CSV Excel spreadsheet every minute. With the code below we can hide and show the file. #region string diret=saveFileDialog1.FileName;...

asked by 13.07.2017 / 11:09

2

answers

USERFORM: What is the difference between the Initialize and Activate routines?

What's the difference between using Initialize and Activate as a userForm's boot routine? Private Sub UserForm_Initialize() Private Sub UserForm_Activate()

asked by 27.04.2017 / 19:23

2

answers

Create spreadsheet by C # without having excel installed [closed]

I'm developing a program that should export data to an Excel spreadsheet. I need to know how to build a spreadsheet with C #, but I only found tutorials that require excel installed on the computer. I would like to be able to export data with...

asked by 09.07.2017 / 16:25

Questions tagged as 'excel'