public static string InitTreeView(string accessToken, string refreshToken) { try { // Make the Auth request to Google SpreadsheetsService sheetsService = GoogleOAuth2.GoogleAuthSheets(accessToken, refreshToken); if (sheetsService == null) { return(""); } // Get list of sheets DriveService driveService = GoogleOAuth2.GoogleAuthDrive(accessToken, refreshToken); if (driveService == null) { return(""); } List <GoogleSheet> sheetList = GoogleDriveHelpers.GoogleRetrieveAllSheets(sheetsService); GoogleFolder root = GoogleDriveHelpers.GoogleRetrieveSheetTree(driveService, null, ref sheetList); System.Xml.Serialization.XmlSerializer x = new System.Xml.Serialization.XmlSerializer(root.GetType()); //using (var stream = new StreamWriter(@"", false)) //{ // x.Serialize(stream, root); //} string xmlStr = GoogleDriveHelpers.SerializeXml <GoogleFolder>(root); xmlStr = xmlStr.Replace("<Children>", "").Replace("<Children />", "").Replace("</Children>", ""); xmlStr = xmlStr.Replace("<Sheets>", "").Replace("<Sheets />", "").Replace("</Sheets>", ""); return(xmlStr); } catch (Exception ex) { return(""); } }