failed to open stream: invalid argument

[karunkshrestha]

I get this error when trying to save csv file to a folder. The folder itself has write permission set correctly.

{"error":{"type":"ErrorException","message":"fopen(/C:\inetpub\wwwroot\learning\laravel-administrator-crud/exports/TestCSVCase.csv): failed to open stream: Invalid argument","file":"C:\inetpub\wwwroot\learning\laravel-administrator-crud\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\CSV.php","line":111}}

[MaatwebsiteSupport]

Hey,

Could you provide the code you used and the Laravel version.

[karunkshrestha]

laravel 4.1 + Frozennode\Administrator + Maatwebsite\Excel

-------------------------- frozennode administrator model --------- ajax to return the file.
return array(
/**

• Model title
  *
• @type string
  */
  'title' => 'Race Courses',

/**

• The singular name of your model
  *
• @type string
  */
  'single' => 'Race Course',

/**

• The class name of the Eloquent model that this config represents
  *
• @type string
  */
  'model' => 'course',

/**

• The columns array
  *
• @type array
  */
  'columns' => array(
  'courseKey'=> array(
  'title' => 'courseId'
  ),
  'name' => array(
  'title' => 'Course Name'
  ),
  'type' => array(
  'title' => 'Course Type'
  ),
  'postcode' => array(
  'title' => 'Postcode'
  )
  ),

/**

• The edit fields array
  *
• @type array
  */
  'edit_fields' => array(
  'name' => array(
  'title' => 'Course Name',
  'type' => 'text'
  ),
  'type' => array(
  'title' => 'Course Type',
  'type' => 'text'
  )
  ),

/**

• The filter fields
  *
• @type array
  */
  'filters' => array(
  'courseKey',
  'name' => array(
  'title' => 'Course Name',
  ),
  'type' => array(
  'title' => 'Course Type',
  'type' => 'text',
  ),
  ),

/**

• The width of the model's edit form
  *
• @type int
  */
  'form_width' => 400,

'global_actions' => array(
'export_to_excel' => array(
'title' => 'Export To Excel',
'messages' => array(
'active' => 'Exporting...',
'success' => 'Spreadsheet created!',
'error' => 'There was an error while creating this spreadsheet',
),
'action' => function($query)
{

        $result = $query->get();

        Excel::create('TestCSVCase')
                ->sheet('SheetName')
                ->with($result->toArray())->save('csv');
    }
),

),

);
?>

[MaatwebsiteSupport]

I tried the Excel part of the code and it just works fine.
When I changed the writing permission, I got your error. After changing back to 777, it works again.
Are you sure the store folder has the correct writing permission, else this error would not be triggered...

[karunkshrestha]

I have taken the excel code out of the laravel administrator section and put it staight into the routes.php

---

Route::get('courses',function(){
$result = Courses::all();
Excel::create('TestCSVCase')
->sheet('SheetName')
->with($result->toArray())->save('csv');
});

---

and i still get the error

I have set full control permission on the 'exports' folder.

still getting the same error.

[MaatwebsiteSupport]

Are you using WAMP?

[karunkshrestha]

I am using iis 7, php 5.5 and mysql 5

On 3 Feb 2014 17:27, Maatwebsite notifications@github.com wrote:
Are you using WAMP?

---

Reply to this email directly or view it on GitHub:
#16 (comment)

[MaatwebsiteSupport]

I'm afraid I can't help you with IIS, I only work with LAMP stacks.
I'm sure it has to do with the write permissions, but I have no idea how this works with IIS.

[karunkshrestha]

thanks for information. I will try to look into the IIS security settings to see if that is what is causing the error

[karunkshrestha]

I have found a fix for it, It looks like you have not considered the windows filepath syntax when saving the excel object.
I have changed the line number 506 in Excel.php so that didn't contain the leading slash in the filepath. it might be a good idea to have both unix and windows filepath when saving the object.

public function store($ext = 'xls', $path = false)
    {

        // Set the default path
        if($path == false)
        {
            $path = Config::get('excel::path');
        }

        // Trim of slashes, to makes sure we won't add them double.
        $path = rtrim($path, '/');
        $path = ltrim($path, '/');

        // Set the extension
        $this->ext = $ext;

        // Render the XLS
        $this->render();

        // Save the file to specified location
        //$this->object->save('/' .$path . '/' . $this->title . '.' . $this->ext);
        $this->object->save($path . '/' . $this->title . '.' . $this->ext);
    }

[mewben]

+1 to this... $this->object->save($path . '/' . $this->title . '.' . $this->ext); worked for me too...

[hm-n2ads]

So, now when I try to use store() with a path, I can't use storage_path() because the front backslash in the path is stripped by the ltrim on line 538 (I'm on a Mac). How am I supposed to store? :-)

Edit: What I am trying to say is that I can't use absolute paths on unix systems anymore?

[MaatwebsiteSupport]

Could you try if it works now.

[hm-n2ads]

It does :-)