You have actually created a sheer, you can verify that there is a sheet by :
var title = applcation.GetSheets().First().SheetMetaData.Title;
Do you have a script? The client does not show the sheets until you have a script.
If you add the following rows to your code you will see the sheet in the client.
pplication.SetScript("Load RecNo() as Dim1 AutoGenerate 100;");
It tests successes I've performed after loading data from an Excel spreadsheet, but I think that the error in this case you have to bring to an event that I've logged in comunity
In fact, if you run before the code:
ISheet mySheet = application.CreateSheet("mySheet");
if (mySheet != null)
mySheet.Properties.MetaDef.Title = "Sheet2";
mySheet.Properties.Rank = 2;
unfortunately are deleted all sheet of QVF and damaged the file ...so the all subsequent tests areare useless
So I recreated a new file ,and I added the following lines to the previous ,and this works
mySheet.SuspendLayout(); //with this work
mySheet.Properties.MetaDef.Title = "Title Sheet";
mySheet.Properties.Rank = 3;
mySheet.ResumeLayout(); //with this work
Unfortunately, the error is due to the fact that in the examples of qliview which explains how to create a sheet is not indicated these warnings
see these examples
We will improve the examples so that are more complete and that they work with the client.
Regarding setting properties have a look at :
// Lars-Göran Book