• 设为首页
  • 点击收藏
  • 手机版
    手机扫一扫访问
    迪恩网络手机版
  • 关注官方公众号
    微信扫一扫关注
    迪恩网络公众号

ios - CSV 上传(转换为电子表格)到 iOS 中的谷歌驱动器?

[复制链接]
菜鸟教程小白 发表于 2022-12-13 06:50:49 | 显示全部楼层 |阅读模式 打印 上一主题 下一主题

我已生成 csv 文件以存储在本地目录路径中。我试图将 csv 文件上传到谷歌驱动器,它工作正常。从谷歌驱动器打开一个 csv 文件,而不是在电子表格中显示预览。所以我想将 csv 文件(将 csv 转换为电子表格)上传到谷歌驱动器。 如何转换?

提前致谢

来自谷歌驱动器的图像

enter image description here

上传 csv 文件到驱动器供您引用的示例:

NSArray *paths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory , NSUserDomainMask, YES);
NSString *documentsDir = [paths objectAtIndex:0];
NSString *root = [documentsDir stringByAppendingPathComponent"Report.csv"];
BOOL fileExists = [[NSFileManager defaultManager] fileExistsAtPath:root];
if(fileExists == YES)
{
        GTLUploadParameters *uploadParameters = nil;
        self.driveFile = [[GTLDriveFile alloc]init];

        NSData *dat = [NSData dataWithContentsOfURL:[NSURL fileURLWithPath:root]];
        uploadParameters =
        [GTLUploadParameters uploadParametersWithData:dat MIMEType"text/csv"];

        self.driveFile.title = @"Report.csv";
        GTLQueryDrive *query = nil;
        if (self.driveFile.identifier == nil || self.driveFile.identifier.length == 0)
        {
            query = [GTLQueryDrive queryForFilesInsertWithObject:self.driveFile
                                                uploadParameters:uploadParameters];
        }
        else
        {
            query = [GTLQueryDrive queryForFilesUpdateWithObject:self.driveFile
                                                          fileId:self.driveFile.identifier
                                                uploadParameters:uploadParameters];
        }
        UIAlertView *alert = [DrEditUtilities showLoadingMessageWithTitle"While data is uploading..."
                                                                 delegate:self];

        [self.driveService executeQuery:query completionHandler:^(GTLServiceTicket *ticket,
                                                                  GTLDriveFile *updatedFile,
                                                                  NSError *error)
         {
            appDel.File_Id = updatedFile.identifier;
            [alert dismissWithClickedButtonIndex:0 animated:YES];
            if (error == nil)
            {
                self.driveFile = updatedFile;

                UIAlertView *alert = [[UIAlertView alloc]initWithTitle"Feel Fix" message"Successfully Uploaded" delegate:self cancelButtonTitle:nil otherButtonTitles"Ok", nil];
                [alert show];
            }
            else
            {
                NSLog(@"An error occurred: %@", error);
                [DrEditUtilities showErrorMessageWithTitle"Unable to save file"
                                                   message:[error description]
                                                  delegate:self];
            }
        }];



Best Answer-推荐答案


插入 Convert 属性来解决这个问题

    GTLUploadParameters *uploadParameters = nil;
    self.driveFile = [[GTLDriveFile alloc]init];

    NSData *dat = [NSData dataWithContentsOfURL:[NSURL fileURLWithPath:root]];
    uploadParameters =
    [GTLUploadParameters uploadParametersWithData:dat MIMEType"text/csv"];

    self.driveFile.title = @"Report.csv";
    GTLQueryDrive *query = nil;
    if (self.driveFile.identifier == nil || self.driveFile.identifier.length == 0)
    {
        query = [GTLQueryDrive queryForFilesInsertWithObject:self.driveFile
                                            uploadParameters:uploadParameters];

        query.convert = YES;   // Convert file format to spread sheet

    }
    else
    {
        query = [GTLQueryDrive queryForFilesUpdateWithObject:self.driveFile
                                                      fileId:self.driveFile.identifier
                                            uploadParameters:uploadParameters];
    }
    UIAlertView *alert = [DrEditUtilities showLoadingMessageWithTitle"While data is uploading..."
                                                             delegate:self];

    [self.driveService executeQuery:query completionHandler:^(GTLServiceTicket *ticket,
                                                              GTLDriveFile *updatedFile,
                                                              NSError *error)
     {
        appDel.File_Id = updatedFile.identifier;
        [alert dismissWithClickedButtonIndex:0 animated:YES];
        if (error == nil)
        {
            self.driveFile = updatedFile;

            UIAlertView *alert = [[UIAlertView alloc]initWithTitle"Feel Fix" message:@"Successfully Uploaded" delegate:self cancelButtonTitle:nil otherButtonTitles:@"Ok", nil];
            [alert show];
        }
        else
        {
            NSLog(@"An error occurred: %@", error);
            [DrEditUtilities showErrorMessageWithTitle:@"Unable to save file"
                                               message:[error description]
                                              delegate:self];
        }
    }];

关于ios - CSV 上传(转换为电子表格)到 iOS 中的谷歌驱动器?,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/22247341/

回复

使用道具 举报

懒得打字嘛,点击右侧快捷回复 【右侧内容,后台自定义】
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

关注0

粉丝2

帖子830918

发布主题
阅读排行 更多
广告位

扫描微信二维码

查看手机版网站

随时了解更新最新资讯

139-2527-9053

在线客服(服务时间 9:00~18:00)

在线QQ客服
地址:深圳市南山区西丽大学城创智工业园
电邮:jeky_zhao#qq.com
移动电话:139-2527-9053

Powered by 互联科技 X3.4© 2001-2213 极客世界.|Sitemap