Open an excel using php and command line/command prompt/ powershell

Question

I want to open an excel and then manipulate the content using php and command line/cmd or powershell.

I have this script already

$data = file("input.csv");
foreach ($data as $line) {
    $lineArray = explode(",", $line);
    list($XXX, $XXX, $XXX, $XXX, $XXX, $XXX) = $lineArray;

    echo $XXX.",".$XXX.",".$XXX.",".$XXX.",".$XXX.",".$XXX;
    echo "\n";
}

I'm just running it in power shell using this

php test.php

What I'm targeting to do is like this

php test.php input.csv

and I will remove the statically coded input.csv

If your question is about how to pass arguments into the script - stackoverflow.com/questions/6826718/… — Nigel Ren
– Nigel Ren, Commented Nov 2, 2019 at 7:43

TheOneNewbie · Accepted Answer · 2019-11-02 07:57:30Z

0

Got it.

I did this

php test.php input.csv

and used the input as an argument

$args = $argv[1];

answered Nov 2, 2019 at 7:57

TheOneNewbie

811 silver badge7 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Open an excel using php and command line/command prompt/ powershell

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related