Excel导入

kim.wade56346
编辑12/09/19 内容基本知识

将Excel电子表格导入新工作表的先决条件是什么?我读取列数,大小和行约束,我的Excel电子表格满足。我得到一个关于字段不能超过50个字符长的警告。这是仅针对主列还是针对所有列?

答案

  • 她名叫Stara
    她名叫Stara ✭✭✭✭✭✭

    嗨,金姆,

    该限制仅适用于列标题,因此如果更改名称或为标题选择另一行,则应该可以工作。

    希望这对你有帮助!

    祝你一周愉快!

    最好的

    她名叫Stara

    工作流程顾问@完成咨询

    智能表专家顾问兼合伙人

    她名叫Stara|工作流程顾问/ CEO @工作大胆

    W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35

    请随时与我联系,了解有关Smartsheet,集成,一般工作流建议或其他方面的帮助。

  • 希瑟Hutchens
    编辑04/26/21

    我正在构建一个流程,其中报告将从第三方软件每月运行,输出为Excel并导入到Smartsheet,以完全取代现有的数据,用于Smartsheet创建的报告,将从网络访问。问题是,我也不能得到导入工作,并得到错误,其中一个字段超过50个字符。

    由于上面的响应说这只适用于列标题-我已经寻找(空白),我的标题都没有那么大。我可以用作主要字段的任何字段的内容也不是。我也试过带和不带公式导入,并首先保存为。csv,但得到相同的50个字符的错误。

    因为我们要定期替换这些数据,所以手工替换不是一个实际的选择。您能提供的任何帮助,以解决这将是非常感激。

  • 她名叫Stara
    她名叫Stara ✭✭✭✭✭✭

    @Heather Hutchens

    我希望你一切安好!

    你能更详细地描述一下你的过程吗分享表格/表格的副本或者一些截图?(在分享之前删除/替换任何机密/敏感信息)这样更容易提供帮助。(分享,(电子邮件保护)

    我希望这对你有帮助!

    注意安全,祝你度过美好的一周!

    最好的

    她名叫Stara|工作流程顾问/ CEO @工作大胆

    我的帖子是否帮助或回答了你的问题或解决了你的问题?请帮助社区将其标记为可接受的答案/有用的.这将使其他人更容易找到解决方案或帮助回答!

    智能表专家顾问兼合伙人

    她名叫Stara|工作流程顾问/ CEO @工作大胆

    W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35

    请随时与我联系,了解有关Smartsheet,集成,一般工作流建议或其他方面的帮助。

  • 我遇到了同样的问题,50个字符长的错误是指指定的Sheet名称。编辑工作表的名称,这应该能解决你的问题。

  • 你说得太对了!文件名必须小于50个字符,否则即使列名小于50个字符,也会出现此错误。

=IF(MONTH(Date@row) = MONTH(TODAY()), \"This Month\", \"Last Month\")<\/p>

You were on the right track.<\/p>

Will the current and previous months be the only options? Will there be entries from prior to last month?<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":106120,"type":"question","name":"PDF Attachment Downloads","excerpt":"We used to be able to click one time on the PDF symbol to open our documents, but now have to click on the three dots and then get this menu and select open in new tab. The single click still works if we are opening a Word document, just not with PDF. Is there a way to get this function back?","categoryID":321,"dateInserted":"2023-06-07T10:34:01+00:00","dateUpdated":"2023-06-07T10:38:21+00:00","dateLastComment":"2023-06-07T13:43:04+00:00","insertUserID":162132,"insertUser":{"userID":162132,"name":"Renee1_CRA","url":"https:\/\/community.smartsheet.com\/profile\/Renee1_CRA","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-07T13:46:45+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-06-07T15:39:07+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":25,"score":null,"hot":3372281225,"url":"https:\/\/community.smartsheet.com\/discussion\/106120\/pdf-attachment-downloads","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106120\/pdf-attachment-downloads","format":"Rich","lastPost":{"discussionID":106120,"commentID":379260,"name":"Re: PDF Attachment Downloads","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379260#Comment_379260","dateInserted":"2023-06-07T13:43:04+00:00","insertUserID":91566,"insertUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-06-07T15:39:07+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/H01NI7XP81IL\/screenshot-2023-06-07-at-11-38-08.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screenshot 2023-06-07 at 11.38.08.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-07T13:48:56+00:00","dateAnswered":"2023-06-07T13:43:04+00:00","acceptedAnswers":[{"commentID":379260,"body":"

Hi @Renee1_CRA<\/a> <\/p>

If you don't want to select the option from the dropdown menu, you can use keyboard shortcuts to open the file in a new tab as well: Ctrl+Click<\/strong> (Windows) or CMD+Click <\/strong>(Mac).<\/p>

Cheers,<\/p>

Genevieve<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":106077,"type":"question","name":"Percentages not displaying correctly in Report Summary","excerpt":"Hi, In this report. I want to total up a number of percentages coming from different sheets. Sometimes the percentages add up as percentages, sometimes they display as an fraction. The source sheets are all from the same template, so should be formatted the same way, though I have noticed that certain files seem to be…","categoryID":321,"dateInserted":"2023-06-06T16:57:43+00:00","dateUpdated":null,"dateLastComment":"2023-06-07T14:55:02+00:00","insertUserID":161188,"insertUser":{"userID":161188,"name":"RRM","title":"Mr","url":"https:\/\/community.smartsheet.com\/profile\/RRM","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nrDn__-bHHo!-ilmN2fAGAI!vHUL5VGglpN","dateLastActive":"2023-06-07T14:54:08+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":161188,"lastUser":{"userID":161188,"name":"RRM","title":"Mr","url":"https:\/\/community.smartsheet.com\/profile\/RRM","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nrDn__-bHHo!-ilmN2fAGAI!vHUL5VGglpN","dateLastActive":"2023-06-07T14:54:08+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":30,"score":null,"hot":3372222765,"url":"https:\/\/community.smartsheet.com\/discussion\/106077\/percentages-not-displaying-correctly-in-report-summary","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106077\/percentages-not-displaying-correctly-in-report-summary","format":"Rich","tagIDs":[265],"lastPost":{"discussionID":106077,"commentID":379287,"name":"Re: Percentages not displaying correctly in Report Summary","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379287#Comment_379287","dateInserted":"2023-06-07T14:55:02+00:00","insertUserID":161188,"insertUser":{"userID":161188,"name":"RRM","title":"Mr","url":"https:\/\/community.smartsheet.com\/profile\/RRM","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nrDn__-bHHo!-ilmN2fAGAI!vHUL5VGglpN","dateLastActive":"2023-06-07T14:54:08+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/9KBOWFBASG02\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-07T14:54:05+00:00","dateAnswered":"2023-06-07T11:56:42+00:00","acceptedAnswers":[{"commentID":379219,"body":"

Hi @RRM<\/a> and @Kleerfyre<\/a> <\/p>

The Support team received other reports of this same behaviour yesterday and were able to identify the cause; this should now be resolved! Please refresh your Report and you should see your percentages appear in the Summary rows again.<\/p>

Cheers,<\/p>

Genevieve<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":265,"urlcode":"Reports","name":"Reports"}]}],"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

使用Smartsheet的趋势