How to delete excel sheet with content?

(0) Share

Report

Posted on by bernardqin

573

I create a job to delete an excel sheet with content but failed, while it works when the sheet is empty. How to delete a sheet which is not empty?

Belowing is the job.

static void Job1(Args _args)
{
SysExcelApplication excel;
SysExcelWorkbooks books;
SysExcelWorkbook book;
SysExcelWorksheets sheets;
SysExcelWorksheet sheet;

excel = SysExcelApplication::construct();
books = excel.workbooks();
books.open("f:\\test.xlsx");
book = books.item(1);
sheets = book.worksheets();
sheet = sheets.itemFromNum(2);
sheet.delete();

excel.visible(true);
}

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (1)

Sort by

Verified answer

Rudi Hansen 4,079 on at

Like (0)

Report
Copy link

Link copied!

I think you need to use excel.displayAlerts(false);

Was this reply helpful? Yes No
Sohaib Cheema 49,668 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Here you go, it does not matter if its excel or word or any other type of file. a file is a file:

boolean fileExists; dialog d; Filename filename; DialogField dialogFilename; ; d = new dialog(); d.caption("select a file to delete."); dialogFilename = d.addField(extendedTypeStr(FilenameOpen)); d.run(); if(d.closedOk()) { filename = dialogFileName.value(); fileExists = WinAPI::fileExists(filename); if(fileExists) { WinAPI::deleteFile(filename); info("File Deleted!"); } }

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 306,446 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

You are trying to delete a sheet with internal number 2. Are you sure this internal number matches your sheet number? Probably you can use the command itemFromName(str _name).

Was this reply helpful? Yes No
Sohaib Cheema 49,668 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

apologies, I thought you are trying to delete file. its excel sheet you are trying. let me remove my verdict

Was this reply helpful? Yes No
bernardqin 573 on at

Like (0)

Report
Copy link

Link copied!

Yes, the sheet number is correct. The sheet2 is deleted if it is empty. After I set cell "A1" to any string, save the excel and run the job again, the sheet cannot be deleted. The job is totally same.

Was this reply helpful? Yes No
Suggested answer

bernardqin 573 on at

Like (0)

Report
Copy link

Link copied!

Thanks your reply. It does work!

Was this reply helpful? Yes No
Rudi Hansen 4,079 on at

Like (0)

Report
Copy link

Link copied!

Please mark the Answer as being the answer then.

Was this reply helpful? Yes No
André Arnaud de Cal... 306,446 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

When you respond to a reply, there is no structure or reference where we can see to which answer you replied on. Can you tell which answer solved your problem? You can click yes or no per answer on the section 'Did this answer your question?'

Was this reply helpful? Yes No