combine two tables from excel before entering the database with php
0
this the code
$sheet = $objPHPExcel->getSheet(0);
//It returns the highest number of rows
$total_rows = $sheet->getHighestRow();
//It returns the highest number of columns
$highest_column = $sheet->getHighestColumn();
echo '<h4>Data from excel file</h4>';
echo '<table cellpadding="5" cellspacing="1" border="1" class="responsive">';
$query = "insert into `presensi` (`nip`, `tanggal`, `jammasuk`, `jampulang`,`jamwaktukerja`,`menitwaktukerja`) VALUES ";
//Loop through each row of the worksheet
for($row =2; $row <= $total_rows; $row++) {
$single_row = $sheet->rangeToArray('A' . $row . ':' . $highest_column . $row, NULL, TRUE, FALSE);
i write like this for combination columns C and D
$single_row3 = $sheet->rangeToArray('C' . $row . '+' . 'D' . $row, NULL, TRUE, FALSE);
php excel
asked Nov 22 '18 at 9:14
kagamikagami
277
add a comment |
0
this the code
$sheet = $objPHPExcel->getSheet(0);
//It returns the highest number of rows
$total_rows = $sheet->getHighestRow();
//It returns the highest number of columns
$highest_column = $sheet->getHighestColumn();
echo '<h4>Data from excel file</h4>';
echo '<table cellpadding="5" cellspacing="1" border="1" class="responsive">';
$query = "insert into `presensi` (`nip`, `tanggal`, `jammasuk`, `jampulang`,`jamwaktukerja`,`menitwaktukerja`) VALUES ";
//Loop through each row of the worksheet
for($row =2; $row <= $total_rows; $row++) {
$single_row = $sheet->rangeToArray('A' . $row . ':' . $highest_column . $row, NULL, TRUE, FALSE);
i write like this for combination columns C and D
$single_row3 = $sheet->rangeToArray('C' . $row . '+' . 'D' . $row, NULL, TRUE, FALSE);
php excel
asked Nov 22 '18 at 9:14
kagamikagami
277
add a comment |
0
0
0
this the code
$sheet = $objPHPExcel->getSheet(0);
//It returns the highest number of rows
$total_rows = $sheet->getHighestRow();
//It returns the highest number of columns
$highest_column = $sheet->getHighestColumn();
echo '<h4>Data from excel file</h4>';
echo '<table cellpadding="5" cellspacing="1" border="1" class="responsive">';
$query = "insert into `presensi` (`nip`, `tanggal`, `jammasuk`, `jampulang`,`jamwaktukerja`,`menitwaktukerja`) VALUES ";
//Loop through each row of the worksheet
for($row =2; $row <= $total_rows; $row++) {
$single_row = $sheet->rangeToArray('A' . $row . ':' . $highest_column . $row, NULL, TRUE, FALSE);
i write like this for combination columns C and D
$single_row3 = $sheet->rangeToArray('C' . $row . '+' . 'D' . $row, NULL, TRUE, FALSE);
php excel
asked Nov 22 '18 at 9:14
kagamikagami
277
this the code
$sheet = $objPHPExcel->getSheet(0);
//It returns the highest number of rows
$total_rows = $sheet->getHighestRow();
//It returns the highest number of columns
$highest_column = $sheet->getHighestColumn();
echo '<h4>Data from excel file</h4>';
echo '<table cellpadding="5" cellspacing="1" border="1" class="responsive">';
$query = "insert into `presensi` (`nip`, `tanggal`, `jammasuk`, `jampulang`,`jamwaktukerja`,`menitwaktukerja`) VALUES ";
//Loop through each row of the worksheet
for($row =2; $row <= $total_rows; $row++) {
$single_row = $sheet->rangeToArray('A' . $row . ':' . $highest_column . $row, NULL, TRUE, FALSE);
i write like this for combination columns C and D
$single_row3 = $sheet->rangeToArray('C' . $row . '+' . 'D' . $row, NULL, TRUE, FALSE);
php excel
php excel
asked Nov 22 '18 at 9:14
kagamikagami
277
asked Nov 22 '18 at 9:14
kagamikagami
277
edited Nov 22 '18 at 9:23
kagami
asked Nov 22 '18 at 9:14
kagamikagami
277
asked Nov 22 '18 at 9:14
kagamikagami
277
asked Nov 22 '18 at 9:14
kagamikagami
277
277
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
1
For range concat operator is : colon. Change it to below statement and it should work.
$single_row3 = $sheet->rangeToArray('C' . $row . ':' . 'D' . $row, NULL, TRUE, FALSE);
Reference Link
Another approach is to get individual cell values (since there are only 2 columns to merge ) and concat the variables as,
$cellValueC = $sheet->getCell('C' . $row)->getValue();
$cellValueD = $sheet->getCell('D' . $row)->getValue();
$concatValue = $cellValueC . ' ' . $cellValueD;
answered Nov 22 '18 at 9:20
SamirSamir
5,2892628
i try, but it show array(1) { [0]=> array(2) { [0]=> float(abdul) [1]=> string(5) "rojak" } }
– kagami
Nov 22 '18 at 9:46
You will have to concat and form a string by reading the array. Have posted another approach too.
– Samir
Nov 22 '18 at 10:30
thank it's work
– kagami
Nov 22 '18 at 11:38
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53427406%2fcombine-two-tables-from-excel-before-entering-the-database-with-php%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
1
For range concat operator is : colon. Change it to below statement and it should work.
$single_row3 = $sheet->rangeToArray('C' . $row . ':' . 'D' . $row, NULL, TRUE, FALSE);
Reference Link
Another approach is to get individual cell values (since there are only 2 columns to merge ) and concat the variables as,
$cellValueC = $sheet->getCell('C' . $row)->getValue();
$cellValueD = $sheet->getCell('D' . $row)->getValue();
$concatValue = $cellValueC . ' ' . $cellValueD;
answered Nov 22 '18 at 9:20
SamirSamir
5,2892628
i try, but it show array(1) { [0]=> array(2) { [0]=> float(abdul) [1]=> string(5) "rojak" } }
– kagami
Nov 22 '18 at 9:46
You will have to concat and form a string by reading the array. Have posted another approach too.
– Samir
Nov 22 '18 at 10:30
thank it's work
– kagami
Nov 22 '18 at 11:38
add a comment |
1
For range concat operator is : colon. Change it to below statement and it should work.
$single_row3 = $sheet->rangeToArray('C' . $row . ':' . 'D' . $row, NULL, TRUE, FALSE);
Reference Link
Another approach is to get individual cell values (since there are only 2 columns to merge ) and concat the variables as,
$cellValueC = $sheet->getCell('C' . $row)->getValue();
$cellValueD = $sheet->getCell('D' . $row)->getValue();
$concatValue = $cellValueC . ' ' . $cellValueD;
answered Nov 22 '18 at 9:20
SamirSamir
5,2892628
i try, but it show array(1) { [0]=> array(2) { [0]=> float(abdul) [1]=> string(5) "rojak" } }
– kagami
Nov 22 '18 at 9:46
You will have to concat and form a string by reading the array. Have posted another approach too.
– Samir
Nov 22 '18 at 10:30
thank it's work
– kagami
Nov 22 '18 at 11:38
add a comment |
1
1
1
For range concat operator is : colon. Change it to below statement and it should work.
$single_row3 = $sheet->rangeToArray('C' . $row . ':' . 'D' . $row, NULL, TRUE, FALSE);
Reference Link
Another approach is to get individual cell values (since there are only 2 columns to merge ) and concat the variables as,
$cellValueC = $sheet->getCell('C' . $row)->getValue();
$cellValueD = $sheet->getCell('D' . $row)->getValue();
$concatValue = $cellValueC . ' ' . $cellValueD;
answered Nov 22 '18 at 9:20
SamirSamir
5,2892628
For range concat operator is : colon. Change it to below statement and it should work.
$single_row3 = $sheet->rangeToArray('C' . $row . ':' . 'D' . $row, NULL, TRUE, FALSE);
Reference Link
Another approach is to get individual cell values (since there are only 2 columns to merge ) and concat the variables as,
$cellValueC = $sheet->getCell('C' . $row)->getValue();
$cellValueD = $sheet->getCell('D' . $row)->getValue();
$concatValue = $cellValueC . ' ' . $cellValueD;
answered Nov 22 '18 at 9:20
SamirSamir
5,2892628
edited Nov 22 '18 at 10:33
answered Nov 22 '18 at 9:20
SamirSamir
5,2892628
answered Nov 22 '18 at 9:20
SamirSamir
5,2892628
answered Nov 22 '18 at 9:20
SamirSamir
5,2892628
5,2892628
i try, but it show array(1) { [0]=> array(2) { [0]=> float(abdul) [1]=> string(5) "rojak" } }
– kagami
Nov 22 '18 at 9:46
You will have to concat and form a string by reading the array. Have posted another approach too.
– Samir
Nov 22 '18 at 10:30
thank it's work
– kagami
Nov 22 '18 at 11:38
add a comment |
i try, but it show array(1) { [0]=> array(2) { [0]=> float(abdul) [1]=> string(5) "rojak" } }
– kagami
Nov 22 '18 at 9:46
You will have to concat and form a string by reading the array. Have posted another approach too.
– Samir
Nov 22 '18 at 10:30
thank it's work
– kagami
Nov 22 '18 at 11:38
i try, but it show array(1) { [0]=> array(2) { [0]=> float(abdul) [1]=> string(5) "rojak" } }
– kagami
Nov 22 '18 at 9:46
i try, but it show array(1) { [0]=> array(2) { [0]=> float(abdul) [1]=> string(5) "rojak" } }
– kagami
Nov 22 '18 at 9:46
You will have to concat and form a string by reading the array. Have posted another approach too.
– Samir
Nov 22 '18 at 10:30
You will have to concat and form a string by reading the array. Have posted another approach too.
– Samir
Nov 22 '18 at 10:30
thank it's work
– kagami
Nov 22 '18 at 11:38
thank it's work
– kagami
Nov 22 '18 at 11:38
add a comment |
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53427406%2fcombine-two-tables-from-excel-before-entering-the-database-with-php%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
