Pruthvi G

Last seen: 2 months ago

53 total contributions since 2019

I love M-scripting

Pruthvi G's Badges

Solved

Maximum value in a matrix
Find the maximum value in the given matrix. For example, if A = [1 2 3; 4 7 8; 0 9 1]; then the answer is 9.

2 months ago

Solved

Find the sum of all the numbers of the input vector
Find the sum of all the numbers of the input vector x. Examples: Input x = [1 2 3 5] Output y is 11 Input x ...

2 months ago

Answered
How can I add a specific autofilter on a column in the excel file
ActiveSheet.Range('10:10').AutoFilter invoke(ActiveSheet.Range('A1:J10'), 'AutoFilter', 10,... %Field {'True'},... %...

5 months ago | 0

Solved

Pizza!
Given a circular pizza with radius _z_ and thickness _a_, return the pizza's volume. [ _z_ is first input argument.] Non-scor...

6 months ago

Answered
Excel files: how to open, edit, and then close file without causing file to become "Read-Only" in MATLAB
Download Link :: https://in.mathworks.com/matlabcentral/fileexchange/71329-delete-excel-workbook-sheets-sheet-1-delete-using-mat...

1 year ago | 0

Answered
How can I delete the default sheets Sheet1, Sheet2 and Sheet3 in Excel, when I use XLSWRITE?
Download Link :: https://in.mathworks.com/matlabcentral/fileexchange/71329-delete-excel-workbook-sheets-sheet-1-delete-using-mat...

1 year ago | 1

Answered
How do I delete worksheets in my Excel file using MATLAB ?
Download Link :: https://in.mathworks.com/matlabcentral/fileexchange/71329-delete-excel-workbook-sheets-sheet-1-delete-using-mat...

1 year ago | 0

Submitted

Delete Excel Workbook Sheets (Sheet 1 delete ) using Matlab
This Script is intended to Delete provided sheets , It can be an Array of sheets also.

1 year ago | 14 downloads |

Answered
Excel Data with Column Names
Download Link :: https://in.mathworks.com/matlabcentral/fileexchange/74993-get-sheet-names-from-excel-file %%******************...

1 year ago | 0

Answered
How do I determine the names and idicies of worksheets in an Excel file using ActiveX?
Download Link :: https://in.mathworks.com/matlabcentral/fileexchange/74993-get-sheet-names-from-excel-file %%******************...

1 year ago | 0

Answered
How can I open an existing Excel file and communicate with it using ActiveX?
Download Link :: https://in.mathworks.com/matlabcentral/fileexchange/74993-get-sheet-names-from-excel-file %%******************...

1 year ago | 0

Answered
How to get the name of a specified excel sheet?
Download Link :: https://in.mathworks.com/matlabcentral/fileexchange/74993-get-sheet-names-from-excel-file %%******************...

1 year ago | 0

Answered
how to read the Sheet name present in any Excel file ?
Download Link :: https://in.mathworks.com/matlabcentral/fileexchange/74993-get-sheet-names-from-excel-file %%******************...

1 year ago | 2

Submitted

Get sheet names from Excel file
Reads the sheet names from Excel file for the given format :: .xls, .xlsm, .xlsx, .xltm, .xltx, .xltm

1 year ago | 9 downloads |

Answered
Finding NaNs in cell array.
Data(cellfun(@(cell) any(isnan(cell(:))),Data))={''};

1 year ago | 0

Answered
Find NaN in a cell array and only delete the NaNs
Data(cellfun(@(cell) any(isnan(cell(:))),Data))={''};

1 year ago | 0

Answered
Remove NaN from doubles within a cell array
ab(cellfun(@(cell) any(isnan(cell(:))),ab))={''};

1 year ago | 0

Answered
Delete rows or column with NaN for a cell array
Data(cellfun(@(cell) any(isnan(cell(:))),Data))={''};

1 year ago | 0

Answered
MATLAB limitation in reading from excel ?!
https://support.office.com/en-us/article/excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3#ID0EBABAAA=Newer_v...

1 year ago | 0

Answered
saving excel file as a new sheet in another excel file using matlab
https://in.mathworks.com/matlabcentral/fileexchange/72901-copy-sheet-from-one-excel-file-to-another-excel-file

1 year ago | 0

Answered
Copy an Excel worksheet from one workbook to another with Matlab
https://in.mathworks.com/matlabcentral/fileexchange/72901-copy-sheet-from-one-excel-file-to-another-excel-file

1 year ago | 1

Answered
How can I use activex to copy an Excel spreadsheet within the same workbook?
https://in.mathworks.com/matlabcentral/fileexchange/72901-copy-sheet-from-one-excel-file-to-another-excel-file

1 year ago | 0

Answered
How to Cope XLS Worksheet using Matlab
https://in.mathworks.com/matlabcentral/fileexchange/72901-copy-sheet-from-one-excel-file-to-another-excel-file

1 year ago | 0

Answered
Copy XLS Sheet
https://in.mathworks.com/matlabcentral/fileexchange/72901-copy-sheet-from-one-excel-file-to-another-excel-file

1 year ago | 0

Answered
Copy and Paste Excel Sheet into New WorkBook
https://in.mathworks.com/matlabcentral/fileexchange/72901-copy-sheet-from-one-excel-file-to-another-excel-file

1 year ago | 0

Answered
How do I copy and paste excel spreadsheets from one excel file to another?
https://in.mathworks.com/matlabcentral/fileexchange/72901-copy-sheet-from-one-excel-file-to-another-excel-file

1 year ago | 0

Answered
Moving excel sheets within excel file
https://in.mathworks.com/matlabcentral/fileexchange/72901-copy-sheet-from-one-excel-file-to-another-excel-file

1 year ago | 0

Submitted

Copy Sheet from one excel file to another excel file
A script intended to copy sheet from one excel file and paste to another and renaming the sheet required.

1 year ago | 17 downloads |

Submitted

Get_Duplicate_array_with_Index
To find the duplicate Values(String) in the Cell array List

2 years ago | 2 downloads |

Answered
Check the license of a toolbox
Run in Command window to get the Version. ver TO get activated licenses please run this command license('test','Database...

2 years ago | 1

| accepted