Google Sheets Query

Google Sheets Query

Posted by: srinivas.suravarapu on 27 August 2025, 9:29 am EST

• 

  srinivas.suravarapu

  • Post Options:
  • Link
    Copy

  Posted 27 August 2025, 9:29 am EST

  Hi

  Is there anyway we can convert a Google sheets workbook into a DSExcel workbook object, is there any potential we could do it using your API? or even alternative advice would be appreciated

  Thank you
  
  Sri

• 

  chirag.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 27 August 2025, 11:05 pm EST

  Hi,

  Based on our understanding, you’re looking to load a Google Sheets workbook (stored in the cloud) directly into a DsExcel Workbook object. While DSExcel doesn’t support directly loading native Google Sheets formats (which are proprietary and cloud-based), it is possible to achieve this programmatically by exporting the sheet to .xlsx format via a URL and loading the resulting stream into DSExcel.

  Please refer to the code snippet below that demonstrates the same:

  string exportUrl = "Google-shareable-xlsx-format-url";
  HttpClient client = new();
  HttpResponseMessage response = await client.GetAsync(exportUrl);
  response.EnsureSuccessStatusCode();
  Stream remoteStream = await response.Content.ReadAsStreamAsync();
  Workbook workbook = new();
  workbook.Open(remoteStream);

  You can further refer to the attached code sample that uses the above code snippet and loads the Google sheet into DsExcel (see below).

  Please let us know if you have any other understanding or require additional assistance.

  Best Regards,
  
  Chirag Gupta

  Attachment: SheetLoad.zip