querytables.add..Invalid argument for URL connection type

  • Thread starter Thread starter jranan
  • Start date Start date
J

jranan

I am trying to dynamically create a web query in an excel workbook project
and am getting an error whenever I try to use a connection of type URL;

Microsoft.Office.Interop.Excel.Range range = worksheet.get_Range("A1", "A1");
Microsoft.Office.Interop.Excel.QueryTable qTable =
worksheet.QueryTables.Add(@"URL;http://localhost/SampleReport", range, null);
qTable.Name = "Test Report";

I am used C# code and this works fine from a embedded VBA module. Why not
from a .NET managed excel workbook?

Any ideas?
 
ps. I am getting an ArgumentException with a description of "The parameter is
incorrect"
 
hi i face the same problem . but i solved that by using "missing.value" instead of null . coz missing .value notifies the compiler that that is an optional argument and its intentionally forgotten . also while decalaring range instead of using "A1" again u can make use of missing . value . Hope that it helps . for using missing . value do remember to add system.reflection
 
Back
Top