Questions tagged as 'excel'

Tagged questions
1
answer

How to insert excel table in mysql using php

I have a table in excel with more than 300 lines and I would like to insert the data of this table in mysql in phpmyadmin Currently php usage Thank you for your attention!     
asked by 25.03.2018 / 00:14
1
answer

Doubt with excel files

I have a list of dates in a BTH.cvs excel file. I want to copy the whole file to another new.cvs, however the a.exe stops working. #include <stdio.h> #include <stdlib.h> int main(int argc,char **argv){ FILE *in = fopen("BTH.cs...
asked by 08.03.2018 / 21:50
1
answer

Script Generate Excel SQL SERVER

I have a select and I need to generate an excel through it. However there are some observations. I would like this script to run every day at a certain time, 23:55 for example, as it is to get the request data open that day. Another question is...
asked by 07.03.2018 / 18:06
1
answer

How to insert photos from a folder into a cell in Excel automatically? [closed]

I need to insert several images in Excel, but it is difficult to insert one by one, there are more than 300 photos, and there will be updates of these photos. I was wondering if there is a way to perform such a procedure?     
asked by 20.03.2018 / 22:50
1
answer

Apache POI: how to tell if a spreadsheet has come to an end?

I'm developing a personal project, and for this I'm using Java along with the Apache POI to read XLS files, how can I tell if the spreadsheet has come to an end? Thank you!     
asked by 10.02.2018 / 04:23
1
answer

How to use the "LOAD DATA INFILE" command?

I have a database and I have a table called "people" which contains "people_id" as an attribute and I want to test how to import information using this title command, I have already saved an excel file in the format ".csv" as follows: link : I...
asked by 12.12.2017 / 18:19
1
answer

Run-time error: 9 - subscript out of range 2

Hi! I'm having problems with this error. I believe that there is some problem in the data that I inserted, but I can not fix it. Calcul des cumuls annuels sur l'année hydrologique (1er septembre au 31 aout) For k = 1 To nbannees - 1...
asked by 21.12.2017 / 16:45
1
answer

xlrd open files in xls format?

I'm sorry for my ignorance on the subject, but I'm developing a Python script that reads Excel files to get certain information in those, and for this I'm using xlrd, I wanted to know if xlrd is able to read xls files too, which is an older Exce...
asked by 17.12.2017 / 18:44
1
answer

Excel: How to make a time series using dynamic table and chart with accumulation of values in the row?

I would like to make a time series chart that would indicate the values accumulated over time. So it would not be a zig-zag line, it would be a line denoting an evolution, as the values are accumulated. To illustrate, attach two images. The f...
asked by 18.12.2017 / 11:46
1
answer

formatting according to cell content

I have a spreadsheet with columns A, B, C, and D where column A, B, and C is a PROCV where you search for the e-mail address in other spreadsheets of each vendor and column D is the name of the person responsible, A, B, and C represent each sale...
asked by 24.10.2017 / 15:07