Tagged Questions
0
votes
0answers
15 views
PHP & Excel, get data from Pivot Table into MySQL
I have been searching EVERYWHERE for the last 3 days. I am going to start using an API that will pull down reports, but those reports are all pivot table based, with hidden data in the background.
I ...
0
votes
0answers
12 views
Automatically import MySQL table entries into google drive spreadsheet
I am building an Excel spreadsheet to track sales from a website. I am doing it on google drive spreadsheets.
My question is regarding a way to link a MySQL database which stores orders to a ...
-4
votes
1answer
29 views
How to process data import to excel sheet from mysql tables using php application [on hold]
How do we import updated table information from backend into same excel sheet incrementally using php
header("Content-Type: application/xls");
$sep = "\t"; //tabbed character
for ($i = 0; $i < ...
0
votes
1answer
26 views
How to print a list of value in Excel, after querying a database?
i've a list of personal function made in Excel VBA.
This function query a mysql database and return only one value.
For example, a function GetRevenue return a single value.
But i'm wondering how ...
0
votes
0answers
14 views
Online Excel Spreedsheet Autosave Values Or how to Connect Spreedsheet to SQL Database
O my god , after 4 days , i start understand that i can,t do anything by my self ,
I create spreedsheet in .htm format with spreedsheetconverter with excel as a table with many formulas and ...
1
vote
1answer
59 views
PHPExcel export data in order to excel
I'm trying to export data in the correct order inside one single xlsx file.
This code below works, but it puts all data into a xlsx file. It pretty much dumps all the data from my database in ...
0
votes
1answer
19 views
PHPEXCEL Set title for all worksheets
I'm trying to change the name of all the worksheets exported into xlsx from my code below.
The export works fine, but the title of all the worksheets are just worksheet 1, 2, 3, etc
I want to grab ...
-1
votes
2answers
46 views
Variable SQL query in Excel
I am looking to create a query in excel that queries to find where a row matches the value that is in a colummn. select a few certain columns.
So, I have data in the form
668406
668406-1
...
1
vote
1answer
56 views
PHP: How to save mysql to excel file to a directory and not prompt user to download
I have got a script that will take my sql statement and convert to excel. I would like the excel file to be saved in a folder instead of prompting to download cause I would like to work on the excel ...
0
votes
1answer
62 views
Importing Excel CSV to MySQL relational database?
I have two tables baskets and fruits; a basket has many different fruits so it's a one to many relation.
The tables are as follows:
baskets
id NOT NULL PRIMARY KEY AUTO_INCREMENT,
basket_name ...
0
votes
1answer
39 views
PHPExcel add multiple sheets for each result PHP mysql
I am trying to add more sheets into a single excel spreadsheet.
What my code below is doing right now is outputting all my data from my php mysql database into worksheet1, and also creating 29 new ...
-3
votes
1answer
64 views
php excel to mysql. convert xls and xlsx both [closed]
I am trying to convert excel to mysql. But I have problems with xls and xlsx. I need a library which supports xls and xlsx together. When I change filename, it should be enough(no change any other ...
1
vote
0answers
15 views
MySQL 5.1 import Excel file from LOAD DATA INFILE
I try to import a simple coma separated .txt file with the "LOAD DATA INFILE" function in my database table but I get this error message
You have an error in your SQL syntax; check the manual that ...
0
votes
0answers
120 views
PhpExcel create sheet for each result row PHP MySQL
I have a question regarding creating one excel file only with PhpExcel, but many worksheets (or whatever you call the extra sheets all inside 1 excel file).
I am trying to export my php mysql data ...
0
votes
0answers
31 views
Fix charset in VBA for mysql query
I have a VBA script in excel which is getting some inserted data and sends it to a Mysql db via ADODB functions.
The problem is that all the accents for french words when are stored in the db get ...
