---
title: "Clear duplicate rows on the local workbook with Swift in Cloud"
description: "Cloud APIs & SDKs for clearing duplicate row on Microsoft Excel & OpenOffice Calc with Swift. Clear duplicate rows on local spreadsheets by the Cells Cloud API SDK for Swift"

---

# Clear duplicate rows on the local workbook with Swift in Cloud


> Cloud APIs & SDKs for clearing duplicate row on Microsoft Excel & OpenOffice Calc with Swift. Clear duplicate rows on local spreadsheets by the Cells Cloud API SDK for Swift





















































.progLangContainer {
padding-right: calc(var(--bs-gutter-x)*.1);
padding-left: calc(var(--bs-gutter-x)*.1)
}
.progLangContainer {
padding-right: calc(var(--bs-gutter-x)*.1);
padding-left: calc(var(--bs-gutter-x)*.1);
margin: 5px;
margin-right: 20px;
}
.progLangPlace .progLangContainer .progLang {
color: #fff;
text-decoration: none;
height: 75px;
width: 75px;
text-align: center;
line-height: 65px;
border-radius: 100%;
font-size: 14px;
font-weight: 700;
border: 5px solid #e5e5e5;
box-shadow: 0 15px 8px -5px #666;
display: inline-block;
direction: ltr !important;
margin-bottom: 15px
}
.progLangPlace .progLangContainer .progLang:hover {
border: 7px solid #e5e5e5;
box-shadow: none
}
.progLangPlace .progLangContainer .bigFont {
font-size: 16px !important;
}
.progLangPlace .progLangContainer .selected {
border: 0 solid #e5e5e5;
box-shadow: 0 10px 8px -5px #666, inset 0 0 0 2px #063c72, inset 0 0 0 5px #fff;
cursor: initial !important;
pointer-events: none
}
.progLang:hover {
border: 7px solid #e5e5e5;
box-shadow: none
}
.progLang {
color: #fff;
text-decoration: none;
height: 75px;
width: 75px;
text-align: center;
line-height: 65px;
border-radius: 100%;
font-size: 14px;
font-weight: 700;
border: 5px solid #e5e5e5;
box-shadow: 0 15px 8px -5px #666;
display: inline-block;
direction: ltr !important;
margin-bottom: 15px
}
.pythonColor {
background: #4a59ce !important;
}
.javaColor {
background: #a499f2 !important;
}
.csColor {
background: #42dbb0 !important;
}
.cppColor {
background: #008594 !important;
}
.phpColor {
background: #ca75d7 !important;
}
.rubyColor {
background: #09e !important;
}
.nodeColor {
background: #519e8a !important;
}
.swiftColor {
background: #a2d270 !important;
}
.goColor {
background: #48d9ee !important;
}
.perlColor {
background: #5c9fea !important;
}
.curlColor {
background: #aeae61 !important;
}
.cellsp {
display: block;
color: #fff;
margin-block-start: 1em;
margin-block-end: 1em;
margin-inline-start: 0px;
margin-inline-end: 0px;
}
.cellsh2, .cellsh1 {
margin-top: 0 !important;
margin-bottom: .5rem !important;
font-weight: 500 !important;
line-height: 1.2 !important;
}
@media (max-width: 868px){
.pf-landing-page-com .header1.minify-header .cellsrow {
display: flex!important;
align-items: center!important;
flex-flow: unset!important;
}
.data-nosnippet{
display:none;
}
.pt-5, .py-5{
padding-top:0px !important;
}
.col-lg-12 .pt-5 .cellsh2{
font-size:18px !important;
margin-top:10px !important;
margin-bottom:10px !important;
}
}
# Swift API to clear duplicate rows on local Microsoft Excel and OpenOffice Calc spreadsheet
## Swift Clear to clear duplicate rows on local Microsoft Excel and OpenOffice Calc spreadsheet
Use Cells Clear REST API to clear duplicate rows on local Microsoft Excel and OpenOffice Calc spreadsheet workflows in Swift. This professional solution clear duplicate rows on local Microsoft Excel and OpenOffice Calc spreadsheet using Swift.
[C#](/cells/net/clear/Duplicate-rows/)
[Java](/cells/java/clear/Duplicate-rows/)
[Python](/cells/python/clear/Duplicate-rows/)
```
[PHP](/cells/php/clear/Duplicate-rows/)
[Go](/cells/go/clear/Duplicate-rows/)
[Node](/cells/nodejs/clear/Duplicate-rows/)
[Ruby](/cells/ruby/clear/Duplicate-rows/)
[Perl](/cells/perl/clear/Duplicate-rows/)
```
.cells_bg_white {
}
@media (max-width: 868px){
.pf-landing-page-com .productfamilypage h2{
font-size:16px !important;
text-align:center !important;
}
.section-layout .heading-border{
font-size:20px !important;
}
}
@media (min-width:1200px){
.section-layout{
width:1170px;margin:0 auto;
line-height:28px;
}
}
```
## Clear duplicate rows on local Microsoft Excel and OpenOffice Calc spreadsheet - Swift REST API
```
.panelContainer {
width: 100%;
}
.cells-cloud-input-group {
display: flex;
margin: 15px auto 0;
border: 1px solid #eee;
border-radius: 10px;
background-color: #ffffff;
align-items: center;
justify-content: space-between
}
.cells-cloud-input-group-main {
flex-grow: 1;
display: inline-block;
padding: 0 4px;
color: #333;
display: inline-block;
}
.cells-cloud-input-group-prepend {
display: inline-block;
height: 52px;
border-radius: 10px 0 0 10px;
padding: 0 20px;
background-color: #e3e3e8;
color: #333;
line-height: 50px
}
.cells-cloud-input-group-method {
float: left;
padding-right: 4px;
color: #ccc;
}
.cells-cloud-input-group-main {
display: inline-block
}
.cells-cloud-input-group-append {
float: right;
}
.cells-cloud-link-button {
display: inline-block;
border: 1px solid transparent;
border-left: 1px solid #e3e3e8;
border-radius: 10px 10px 10px 10px;
padding: 0 20px;
outline: none;
box-shadow: none;
background-color: #1a89d0;
text-align: center;
vertical-align: middle;
color: #151617;
line-height: 20px;
font-size: 1rem;
font-weight: 400;
}
.cells-api-text{
text-align: center;
vertical-align: middle;
color: #151617;
line-height: 50px;
font-size: 1rem;
margin: 0 auto;
width: fit-content;
font-weight: 400;
}
.cells-cloud-action-button {
display: inline-block;
width: 100%;
border: 1px solid transparent;
border-left: 1px solid #e3e3e8;
border-radius: 10px 10px 10px 10px;
padding: 0 20px;
outline: none;
box-shadow: none;
text-align: center;
vertical-align: middle;
line-height: 50px;
font-size: 1rem;
margin: 0 auto;
width: fit-content;
font-weight: 400;
}
@media (max-width: 868px){
.cells-cloud-input-group-prepend,.cells-cloud-input-group-method{
display:none !important;
}
.cells-cloud-input-group-main{
padding:0px !important;
}
.spanclass{
float: left;
width: 70%;
overflow: hidden;
}
}
API 
POST 
https://api.aspose.cloud/v3.0/cells/clear
Try it 
Clearing duplicate rows on local Microsoft Excel and OpenOffice Calc spreadsheet is a complex task. Clearing duplicate rows on local Microsoft Excel and OpenOffice Calc spreadsheet transitions is performed by our Swift SDK while maintaining the source spreadsheet's main structural and logical content. Our Swift library is a professional solution to Clear duplicate rows on local Microsoft Excel and OpenOffice Calc spreadsheet online. This Cloud SDK gives Swift developers powerful functionality and perfect API.
### Swift code for clearing duplicate rows on local spreadsheets
```
```
console.log("")
var codeconent = document.getElementById('code-convert');
codeconent.innerHTML = "";
const originalContent = "";
let dynamicReplacement = "";
function updateDynamicContent(value) {
dynamicReplacement = value;
updateDisplay();
}
function updateDisplay() {
const modifiedContent = originalContent.replace(/Book1\.xml/g, dynamicReplacement);
```
console.log(modifiedContent);
```
codeconent.innerHTML = modifiedContent;
}
.section-list{
}
.section-list ul{
display: flex;
flex-direction: row;
justify-content: space-between;
padding: 0px;
}
.section-list li{
list-style: none;
width: 27%;
line-height: 34px;
padding: 15px;
border-radius: 5px;
padding-top: 25px;
padding-bottom: 25px;
font-weight: bold;
word-break: break-all;
display: inline-block;
border: 1px dashed;
margin-bottom: 20px;
margin-right: 0px;
}
.section-list svg{
margin-top: -20px;
margin-left:1%;
margin-right:1%;
}
.heading-border{
font-size:28px !important;
width:100% !important;
padding-bottom:20px;
}
@media (min-width: 1200px){
.howtosection{
width: 1170px !important;
margin:0 auto !important;
}
.olstyle{
width: 1170px !important;
margin:0 auto !important;
}
```
}
```
@media (max-width: 868px){
.olstyle h2{
font-size:20px !important;
}
}
.olstyle ol{
list-style-type: none;
margin-right: 0;
margin-bottom: 0;
margin-left: 16px;
padding-top: 0;
padding-right: 0;
padding-bottom: 0;
padding-left: 30px;
}
.olstyle li{
margin-right: 0 !important;
line-height: 30px;
position: relative;
margin-bottom: 10px;
font-size: 18px;
}
.olstyle li a{
font-weight:bold;
text-decoration: underline !important;
}
.olstyle li::before{
position: absolute;
left: -30px;
top: 5px;
display: block;
background: #006bb0;
width: 20px;
height: 20px;
color: #fff;
text-align: center;
line-height: 20px;
font-size: 12px;
font-weight: 700;
border-radius: 10px;
}
```
.olstyle li:nth-child(1):before {
content: "1"
```
}
.olstyle li:nth-child(2):before {
content: “2”
}
.olstyle li:nth-child(3):before {
content: “3”
}
.olstyle li:nth-child(4):before {
content: “4”
}
.olstyle li:nth-child(5):before {
content: “5”
}
.olstyle li:nth-child(6):before {
content: “6”
}
.olstyle li:nth-child(7):before {
content: “7”
}
```
## How to use Swift API to clear duplicate rows 
```
- Create an account at [Dashboard](https://dashboard.aspose.cloud/) to get free API quota & authorization details
- Initialize CellsApi with Client Id, Client Secret, Base URL & API version
- Call postClearObjects method to get the resultant stream
```
```
.section-list{
}
.section-list ul{
display: flex;
flex-direction: row;
justify-content: space-between;
padding: 0px;
}
.section-list li{
list-style: none;
width: 27%;
line-height: 34px;
padding: 15px;
border-radius: 5px;
padding-top: 25px;
padding-bottom: 25px;
font-weight: bold;
word-break: break-all;
display: inline-block;
border: 1px dashed;
margin-bottom: 20px;
margin-right: 0px;
}
.section-list svg{
margin-top: -20px;
margin-left:1%;
margin-right:1%;
}
.heading-border{
font-size:28px !important;
width:100% !important;
padding-bottom:20px;
}
@media (min-width: 1200px){
.howtosection{
width: 1170px !important;
margin:0 auto !important;
}
.olstyle{
width: 1170px !important;
margin:0 auto !important;
}
```
}
```
@media (max-width: 868px){
.olstyle h2{
font-size:20px !important;
}
}
.olstyle ol{
list-style-type: none;
margin-right: 0;
margin-bottom: 0;
margin-left: 16px;
padding-top: 0;
padding-right: 0;
padding-bottom: 0;
padding-left: 30px;
}
.olstyle li{
margin-right: 0 !important;
line-height: 30px;
position: relative;
margin-bottom: 10px;
font-size: 18px;
}
.olstyle li a{
font-weight:bold;
text-decoration: underline !important;
}
.olstyle li::before{
position: absolute;
left: -30px;
top: 5px;
display: block;
background: #006bb0;
width: 20px;
height: 20px;
color: #fff;
text-align: center;
line-height: 20px;
font-size: 12px;
font-weight: 700;
border-radius: 10px;
}
```
.olstyle li:nth-child(1):before {
content: "1"
```
}
.olstyle li:nth-child(2):before {
content: “2”
}
.olstyle li:nth-child(3):before {
content: “3”
}
.olstyle li:nth-child(4):before {
content: “4”
}
.olstyle li:nth-child(5):before {
content: “5”
}
.olstyle li:nth-child(6):before {
content: “6”
}
.olstyle li:nth-child(7):before {
content: “7”
}
```
## System Requirements
```
- macOS Monterey 12.4
- Swift 4.2
```
```