cancel
Showing results for 
Search instead for 
Did you mean: 

Saving XL file gives disc full error

Valued Contributor

Saving XL file gives disc full error

Hi,

When I' saving excel file in script gives "disck full" error.

have around 45GB file is just 75KB.

 

following is code...

function WriteExcelSheet(){
var todayD, hireDate ;
  var xlRange,rowCount,adjtTotal;
  var app = Sys.OleObject("Excel.Application");
  var book = app.Workbooks.Open(dtaFile);
  var sheet = book.Sheets('mySheet');
  todayD = aqDateTime.Today();
  hireDate = aqDateTime.AddDays(todayD, -85);
  Log.Message(aqConvert.DateTimeToStr(myDate));
  app.DisplayAlerts = false;
  app.Visible = true;
  //xlRange = app.Range('A1').Activate(); 
  
  rowCount = sheet.UsedRange.Rows.Count+1
  Log.Message('Number of rows = '+rowCount);

  for(j=11;j<rowCount;j++){
      app.Cells(j,10) = hireDate;
       }
  book.Save();
  Delay(7000);
  app.Quit();
}

the error fire at  book.Save();

 

This dosn't happen ervery time but after running long time randomly

5 REPLIES 5
Highlighted
Community Hero

Re: Saving XL file gives disc full error

I'm wondering if "Disc Full" is not exactly the correct erro, even if that's what's being returned.  I tcould be permissions or access on the folder in question.


Robert Martin
[Community Expert Group]
Please consider giving a Kudo if I write good stuff
----

Why automate?  I do automated testing because there's only so much a human being can do and remain healthy.  Sleep is a requirement.  So, while people sleep, automation that I create does what I've described above in order to make sure that nothing gets past the final defense of the testing group.
I love good food, good books, good friends, and good fun.

Mysterious Gremlin Master
Extensions available
Community Manager

Re: Saving XL file gives disc full error

Hi @NisHera,

 

Was the cause of the problem related to permissions?

 

---------
Tanya Gorbunova
SmartBear Community Manager

Did my reply answer your question? Give Kudos or Accept it as a Solution to help others.↓↓↓↓↓
Valued Contributor

Re: Saving XL file gives disc full error

not sure ..!

there are security changes being happeing ..so could be it.

Community Manager

Re: Saving XL file gives disc full error

Just to clarify - was the issue resolved?

---------
Tanya Gorbunova
SmartBear Community Manager

Did my reply answer your question? Give Kudos or Accept it as a Solution to help others.↓↓↓↓↓
New Member

Re: Saving XL file gives disc full error


@9apps download wrote:

Just to clarify - was the issue resolved?


Sorry but not familiar with the topic.

New Here?
Join us and watch the welcome video:
6 / 7 API Testing Mistakes Video
Top Kudoed Authors