Community Profile

# Pruthvi G

##### Last seen: 2 months ago
53 total contributions since 2019

I love M-scripting

View details...

Contributions in
View by

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

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

Excel files: how to open, edit, and then close file without causing file to become "Read-Only" in MATLAB

1 year ago | 0

How can I delete the default sheets Sheet1, Sheet2 and Sheet3 in Excel, when I use XLSWRITE?

1 year ago | 1

How do I delete worksheets in my Excel file using MATLAB ?

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.

Excel Data with Column Names

1 year ago | 0

How do I determine the names and idicies of worksheets in an Excel file using ActiveX?

1 year ago | 0

How can I open an existing Excel file and communicate with it using ActiveX?

1 year ago | 0

How to get the name of a specified excel sheet?

1 year ago | 0

how to read the Sheet name present in any 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

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

1 year ago | 0

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

1 year ago | 0

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

1 year ago | 0

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

1 year ago | 0

MATLAB limitation in reading from excel ?!

1 year ago | 0

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

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

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

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

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

1 year ago | 0

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

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

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.

Submitted

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