i cannot upload the response file(excel) ; its fine while uploading the predictor

Question

SABARIESWARAN A 2022-3-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1674054-i-cannot-upload-the-response-file-excel-its-fine-while-uploading-the-predictor

回答： Dinesh 2023-12-22

function [newData1] = importfile(fileToRead1)

%IMPORTFILE(FILETOREAD1)

% Imports data from the specified file

% FILETOREAD1: file to read

% Auto-generated by MATLAB on 17-Mar-2022 21:31:45

% Import the file

sheetName='Sheet1';

[numbers, strings, raw] = xlsread(fileToRead1, sheetName); %#ok<XLSRD>

if ~isempty(numbers)

newData1.data = numbers;

end

if ~isempty(strings)

newData1.textdata = strings;

end

if ~isempty(strings) && ~isempty(numbers)

[strRows, strCols] = size(strings);

[numRows, numCols] = size(numbers);

likelyRow = size(raw,1) - numRows;

% Break the data up into a new structure with one field per column.

if strCols == numCols && likelyRow > 0 && strRows >= likelyRow

newData1.colheaders = strings(likelyRow, :);

end

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Dinesh 2023-12-22

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1674054-i-cannot-upload-the-response-file-excel-its-fine-while-uploading-the-predictor#answer_1376212

在 MATLAB Online 中打开

Hello.

The issue is that the Excel file you're trying to upload as a response isn't being accepted, possibly due to the file size or format limitations (inferred from your code). This can occur if the upload mechanism doesn't support the specific Excel file size or if the file format isn't recognized by the system's configuration. To resolve this, ensure the file conforms to size limits, check for the correct file format, and verify that your system has the appropriate permissions set for the file upload.

If needed, here's a code snippet for checking file size before attempting the upload in MATLAB:

fileInfo = dir(fileToRead1);
if fileInfo.bytes < uploadLimitBytes
    % Proceed with file upload
else
    error('File exceeds the maximum allowed size for upload.');
end